Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » UltraLite - .NET Programming » UltraLite .NET 1.0 API Reference » ULDataReader class

ULDataReader class Next Page

ULDataReader members


Public properties
Member nameDescription
Depth property

Returns the depth of nesting for the current row. The outermost table has a depth of zero.

FieldCount property

Returns the number of columns in the cursor.

IsBOF property

UL Ext.: Checks whether the current row position is before the first row.

IsClosed property

Checks whether the cursor is currently open.

IsEOF property

UL Ext.: Checks whether the current row position is after the last row.

Item property

Returns the value of the specified column in its native format. In C#, this property is the indexer for the ULDataReader class.

Item property

Returns the value of the specified named column in its native format. In C#, this property is the indexer for the ULDataReader class.

RecordsAffected property

Returns the number of rows changed, inserted, or deleted by execution of the SQL statement. For SELECT statements or CommandType.TableDirect tables, this value is -1.

RowCount property

UL Ext.: Returns the number of rows in the cursor.

Schema property

UL Ext.: Holds the schema of this cursor.

Public methods
Member nameDescription
Close method

Closes the cursor.

Dispose method

Releases the unmanaged resources used by the ULDataReader and optionally releases the managed resources.

GetBoolean method

Returns the value for the specified column as a System.Boolean.

GetByte method

Returns the value for the specified column as an unsigned 8-bit value (System.Byte).

GetBytes method

Copies a subset of the value for the specified ULDbType.LongBinary column, beginning at the specified offset, to the specified offset of the destination System.Byte array.

GetBytes method

UL Ext.: Returns the value for the specified column as an array of System.Bytes. Only valid for columns of type ULDbType.Binary, ULDbType.LongBinary, or ULDbType.UniqueIdentifier.

GetChar method

This method is not supported in UltraLite.NET.

GetChars method

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

This method is not supported in UltraLite.NET.

GetDataTypeName method

Returns the name of the specified column's provider data type.

GetDateTime method

Returns the value for the specified column as a System.DateTime with millisecond accuracy.

GetDecimal method

Returns the value for the specified column as a System.Decimal.

GetDouble method

Returns the value for the specified column as a System.Double.

GetFieldType method

Returns the System.Type most appropriate for the specified column.

GetFloat method

Returns the value for the specified column as a System.Single.

GetGuid method

Returns the value for the specified column as a UUID (System.Guid).

GetInt16 method

Returns the value for the specified column as a System.Int16.

GetInt32 method

Returns the value for the specified column as an Int32.

GetInt64 method

Returns the value for the specified column as an Int64.

GetName method

Returns the name of the specified column.

GetOrdinal method

Returns the column ID of the named column.

GetSchemaTable method

Returns a System.Data.DataTable that describes the column metadata of the ULDataReader.

GetString method

Returns the value for the specified column as a System.String.

GetTimeSpan method

Returns the value for the specified column as a System.TimeSpan with millisecond accuracy.

GetUInt16 method

Returns the value for the specified column as a System.UInt16.

GetUInt32 method

Returns the value for the specified column as a UInt32.

GetUInt64 method

Returns the value for the specified column as a System.UInt64.

GetValue method

Returns the value of the specified column in its native format.

GetValues method

Returns all the column values for the current row.

IsDBNull method

Checks whether the value from the specified column is NULL.

MoveAfterLast method

UL Ext.: Positions the cursor to after the last row of the cursor.

MoveBeforeFirst method

UL Ext.: Positions the cursor to before the first row of the cursor.

MoveFirst method

UL Ext.: Positions the cursor to the first row of the cursor.

MoveLast method

UL Ext.: Positions the cursor to the last row of the cursor.

MoveNext method

UL Ext.: Positions the cursor to the next row or after the last row if the cursor was already on the last row.

MovePrevious method

UL Ext.: Positions the cursor to the previous row or before the first row.

MoveRelative method

UL Ext.: Positions the cursor relative to the current row.

NextResult method

Advances the ULDataReader to the next result when reading the results of batch SQL statements.

Read method

Positions the cursor to the next row, or after the last row if the cursor was already on the last row.

Protected methods
Member nameDescription
Finalize method

Releases the unmanaged resources used by the ULDataReader.