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

SQL Anywhere 10.0.1 » SQL Anywhere Server - Programming » SQL Anywhere .NET 2.0 API Reference » SADataReader class

SADataReader class Next Page

SADataReader members


Public properties
Member nameDescription
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 Gets the value of a specified column as an instance of [external link] Object.
RecordsAffected property The number of rows changed, inserted, or deleted by execution of the SQL statement.
[external link] VisibleFieldCount (inherited from DbDataReader)
Public methods
Member nameDescription
Close method Closes the SADataReader.
[external link] Dispose (inherited from 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)
[external link] GetProviderSpecificValue (inherited from DbDataReader)
[external link] GetProviderSpecificValues (inherited from DbDataReader)
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