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

SQL Anywhere 11.0.0 » SQL Anywhere Server - Programming » SQL Anywhere Data Access APIs » SQL Anywhere .NET 2.0 API Reference » iAnywhere.Data.SQLAnywhere namespace (.NET 2.0) » SADataReader class

 

SADataReader members

Public properties
Member name Description

Depth property

Gets a value indicating the depth of nesting for the current row. The outermost table has a depth of zero.

FieldCount property

Gets the number of columns in the result set.

HasRows property

Gets a value that indicates whether the SADataReader contains one or more rows.

IsClosed property

Gets a values that indicates whether the SADataReader is closed.

Item properties

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

RecordsAffected property

The number of rows changed, inserted, or deleted by execution of the SQL statement.

[external link] VisibleFieldCount (inherited from DbDataReader)

Gets the number of fields in the [external link] DbDataReader that are not hidden.

Public methods
Member name Description

Close method

Closes the SADataReader.

[external link] Dispose (inherited from DbDataReader)

Releases all resources used by the current instance of the [external link] DbDataReader.

GetBoolean method

Returns the value of the specified column as a Boolean.

GetByte method

Returns the value of the specified column as a Byte.

GetBytes method

Reads a stream of bytes from the specified column offset into the buffer as an array, starting at the given buffer offset.

GetChar method

Returns the value of the specified column as a character.

GetChars method

Reads a stream of characters from the specified column offset into the buffer as an array starting at the given buffer offset.

GetData method

This method is not supported. When called, it throws an InvalidOperationException.

GetDataTypeName method

Returns the name of the source data type.

GetDateTime method

Returns the value of the specified column as a DateTime object.

GetDecimal method

Returns the value of the specified column as a Decimal object.

GetDouble method

Returns the value of the specified column as a double-precision floating point number.

GetEnumerator method

Returns a [external link] IEnumerator that iterates through the SADataReader object.

GetFieldType method

Returns the Type that is the data type of the object.

GetFloat method

Returns the value of the specified column as a single-precision floating point number.

GetGuid method

Returns the value of the specified column as a global unique identifier (GUID).

GetInt16 method

Returns the value of the specified column as a 16-bit signed integer.

GetInt32 method

Returns the value of the specified column as a 32-bit signed integer.

GetInt64 method

Returns the value of the specified column as a 64-bit signed integer.

GetName method

Returns the name of the specified column.

GetOrdinal method

Returns the column ordinal, given the column name.

[external link] GetProviderSpecificFieldType (inherited from DbDataReader)

Returns the provider-specific field type of the specified column.

[external link] GetProviderSpecificValue (inherited from DbDataReader)

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

[external link] GetProviderSpecificValues (inherited from DbDataReader)

Gets all provider-specific attribute columns in the collection for the current row.

GetSchemaTable method

Returns a DataTable that describes the column metadata of the SADataReader.

GetString method

Returns the value of the specified column as a string.

GetTimeSpan method

Returns the value of the specified column as a TimeSpan object.

GetUInt16 method

Returns the value of the specified column as a 16-bit unsigned integer.

GetUInt32 method

Returns the value of the specified column as a 32-bit unsigned integer.

GetUInt64 method

Returns the value of the specified column as a 64-bit unsigned integer.

GetValue methods

Returns the value of the specified column as an Object.

GetValues method

Gets all the columns in the current row.

IsDBNull method

Returns a value indicating whether the column contains NULL values.

NextResult method

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

Read method

Reads the next row of the result set and moves the SADataReader to that row.

myDispose method

Frees the resources associated with the object.

See also