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

SQL Anywhere 11.0.1 » 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

A read-only, forward-only result set from a query or stored procedure. This class cannot be inherited.

Visual Basic

Public NotInheritable Class SADataReader 
  Inherits DbDataReader
  Implements IListSource

public sealed class SADataReader : DbDataReader,

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:[external link] IDataReader, [external link] IDisposable, [external link] IDataRecord, [external link] IListSource

For more information, see Accessing and manipulating data.

See also

SADataReader members
Depth property
FieldCount property
HasRows property
IsClosed property
Item properties
RecordsAffected property
Close method
GetBoolean method
GetByte method
GetBytes method
GetChar method
GetChars method
GetData method
GetDataTypeName method
GetDateTime method
GetDecimal method
GetDouble method
GetEnumerator method
GetFieldType method
GetFloat method
GetGuid method
GetInt16 method
GetInt32 method
GetInt64 method
GetName method
GetOrdinal method
GetSchemaTable method
GetString method
GetTimeSpan method
GetUInt16 method
GetUInt32 method
GetUInt64 method
GetValue methods
GetValues method
IsDBNull method
NextResult method
Read method
myDispose method