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 2.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.

HasRows property

Checks whether the ULDataReader has one or more rows.

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 properties

Gets the value of a specified column as an instance of [external link] Object.

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.

[external link] VisibleFieldCount (inherited from DbDataReader)

Public methods
Member nameDescription

Close method

Closes the cursor.

[external link] Dispose (inherited from DbDataReader)

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 methods

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.

[external link] GetData (inherited from DbDataReader)

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.

GetEnumerator method

Returns an System.Collections.IEnumerator that iterates through the ULDataReader.

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.

[external link] GetProviderSpecificFieldType (inherited from DbDataReader)

[external link] GetProviderSpecificValue (inherited from DbDataReader)

[external link] GetProviderSpecificValues (inherited from DbDataReader)

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.

See also