SADataReader class

A read-only, forward-only result set from a query or stored procedure.

Visual Basic syntax

Public NotInheritable Class SADataReader
    Inherits System.Data.Common.DbDataReader
    Implements System.ComponentModel.IListSource

C# syntax

public sealed class SADataReader : 
    System.Data.Common.DbDataReader, 
    System.ComponentModel.IListSource

Members

All members of SADataReader class, including all inherited members.

Name	Description
Close method	Closes the SADataReader.
Dispose method (Inherited from System.Data.Common.DbDataReader)	Releases all resources used by the current instance of the System.Data.Common.DbDataReader class.
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.
GetDataTypeName method	Returns the name of the source data type.
GetDateTime method	Returns the value of the specified column as a DateTime object.
GetDateTimeOffset method	Returns the value of the specified column as a DateTimeOffset object.
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.
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 System.Collections.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.
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.
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 method	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.
myDispose method	Frees the resources associated with the object.
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.
Depth property	Gets a value indicating the depth of nesting for the current row.
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.
RecordsAffected property	The number of rows changed, inserted, or deleted by execution of the SQL statement.
this property	Returns the value of a 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.

Remarks

There is no constructor for SADataReader. To get an SADataReader object, execute an SACommand:

SACommand cmd = new SACommand(
    "SELECT EmployeeID FROM Employees", conn );
SADataReader reader = cmd.ExecuteReader();

You can only move forward through an SADataReader. If you need a more flexible object to manipulate results, use an SADataAdapter.

The SADataReader retrieves rows as needed, whereas the SADataAdapter 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 SADataReader a much faster response time.

Implements: IDataReader, IDisposable, IDataRecord, IListSource

For more information, see Accessing and manipulating data.