Represents a read-only bi-directional cursor in an UltraLite database.
Public Class ULDataReader Inherits System.Data.Common.DbDataReader Implements System.ComponentModel.IListSource
public class ULDataReader : System.Data.Common.DbDataReader, System.ComponentModel.IListSource
All members of ULDataReader class, including all inherited members.
Name | Description |
---|---|
Closes the cursor. | |
Dispose method (Inherited from System.Data.Common.DbDataReader) |
Releases all resources used by the current instance of the System.Data.Common.DbDataReader class. |
Returns the value for the specified column as a System.Boolean. | |
Returns the value for the specified column as an unsigned 8-bit value (System.Byte). | |
UL Ext: Returns the value for the specified column as an array of System.Bytes. | |
This method is not supported in UltraLite.NET. | |
Copies a subset of the value for the specified ULDbType.LongVarchar column, beginning at the specified offset, to the specified offset of the destination System.Char array. | |
GetData method (Inherited from System.Data.Common.DbDataReader) |
Returns a System.Data.Common.DbDataReader object for the requested column ordinal. |
Returns the name of the specified column's provider data type. | |
Returns the value for the specified column as a System.DateTime with millisecond accuracy. | |
GetDbDataReader method (Inherited from System.Data.Common.DbDataReader) |
Returns a System.Data.Common.DbDataReader object for the requested column ordinal that can be overridden with a provider-specific implementation. |
Returns the value for the specified column as a System.Decimal. | |
Returns the value for the specified column as a System.Double. | |
Returns an System.Collections.IEnumerator that iterates through the ULDataReader. | |
Returns the System.Type most appropriate for the specified column. | |
Returns the value for the specified column as a System.Single. | |
Returns the value for the specified column as a UUID (System.Guid). | |
Returns the value for the specified column as a System.Int16. | |
Returns the value for the specified column as an Int32. | |
Returns the value for the specified column as an Int64. | |
Returns the name of the specified column. | |
Returns the column ID of the named column. | |
GetProviderSpecificFieldType method (Inherited from System.Data.Common.DbDataReader) |
Returns the provider-specific field type of the specified column. |
GetProviderSpecificValue method (Inherited from System.Data.Common.DbDataReader) |
Gets the value of the specified column as an instance of System.Object. |
GetProviderSpecificValues method (Inherited from System.Data.Common.DbDataReader) |
Gets all provider-specific attribute columns in the collection for the current row. |
UL Ext: Returns the number of rows in the cursor, within threshold. | |
Returns a System.Data.DataTable that describes the column metadata of the ULDataReader. | |
Returns the value for the specified column as a System.String. | |
Returns the value for the specified column as a System.TimeSpan with millisecond accuracy. | |
Returns the value for the specified column as a System.UInt16. | |
Returns the value for the specified column as a UInt32. | |
Returns the value for the specified column as a System.UInt64. | |
Returns the value of the specified column in its native format. | |
Returns all the column values for the current row. | |
Checks whether the value from the specified column is NULL. | |
UL Ext: Positions the cursor to after the last row of the cursor. | |
UL Ext: Positions the cursor to before the first row of the cursor. | |
UL Ext: Positions the cursor to the first row of the cursor. | |
UL Ext: Positions the cursor to the last row of the cursor. | |
UL Ext: Positions the cursor to the next row or after the last row if the cursor was already on the last row. | |
UL Ext: Positions the cursor to the previous row or before the first row. | |
UL Ext: Positions the cursor relative to the current row. | |
Advances the ULDataReader to the next result when reading the results of batch SQL statements. | |
Positions the cursor to the next row, or after the last row if the cursor was already on the last row. | |
Returns the depth of nesting for the current row. | |
Returns the number of columns in the cursor. | |
Checks whether the ULDataReader has one or more rows. | |
UL Ext: Checks whether the current row position is before the first row. | |
Checks whether the cursor is currently open. | |
UL Ext: Checks whether the current row position is after the last row. | |
Returns the number of rows changed, inserted, or deleted by execution of the SQL statement. | |
UL Ext: Returns the number of rows in the cursor. | |
UL Ext: Holds the schema of this cursor. | |
Returns the value of the specified column in its native format. | |
VisibleFieldCount property (Inherited from System.Data.Common.DbDataReader) |
Gets the number of fields in the System.Data.Common.DbDataReader that are not hidden. |
Cursors are sets of rows from either a table or the result set from a query.
There is no constructor for ULDataReader. To get a ULDataReader object, execute a ULCommand:
' Visual Basic Dim cmd As ULCommand = new ULCommand( _ "SELECT emp_id FROM employee", conn _ ) Dim reader As ULDataReader = cmd.ExecuteReader() |
The following code is the C# language equivalent:
// C# ULCommand cmd = new ULCommand( "SELECT emp_id FROM employee", conn ); ULDataReader reader = cmd.ExecuteReader(); |
UL Ext: The ADO.NET standard only requires forward-only motion through the result set, but ULDataReader is bi-directional. ULDataReader's Move methods provide you with full flexibility when moving through results.
ULDataReader is a read-only result set. If you need a more flexible object to manipulate results, use a ULCommand.ExecuteResultSet(), ULCommand.ExecuteTable(), or a ULDataAdapter. ULDataReader retrieves rows as needed, whereas ULDataAdapter must retrieve all rows of a result set before you can carry out any action on the object. For large result sets, this difference gives the ULDataReader a much faster response time.
UL Ext: All columns of a ULDataReader may be retrieved using GetString.
Close method
GetBoolean method
GetByte method
GetBytes method
GetChar method
GetChars method
GetDataTypeName method
GetDateTime method
GetDecimal method
GetDouble method
GetEnumerator method
GetFieldType method
GetFloat method
GetGuid method
GetInt16 method
GetInt32 method
GetInt64 method
GetName method
GetOrdinal method
GetRowCount method
GetSchemaTable method
GetString method
GetTimeSpan method
GetUInt16 method
GetUInt32 method
GetUInt64 method
GetValue method
GetValues method
IsDBNull method
MoveAfterLast method
MoveBeforeFirst method
MoveFirst method
MoveLast method
MoveNext method
MovePrevious method
MoveRelative method
NextResult method
Read method
Depth property
FieldCount property
HasRows property
IsBOF property
IsClosed property
IsEOF property
RecordsAffected property
RowCount property
Schema property
this property
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |