ASA Programming Guide
  Adaptive Server Anywhere .NET Data Provider API Reference

AsaDataReader class

Description 

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

Base classes 

MarshalByRefObject

Implemented interfaces 

IDataReader, IDisposable, IDataRecord

Usage 

There is no constructor for AsaDataReader. To get an AsaDataReader object, execute an AsaCommand:

AsaCommand cmd = new AsaCommand(
    "Select emp_id from employee", conn );
AsaDataReader reader = cmd.ExecuteReader();

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

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

See also 

ExecuteReader method

Accessing and manipulating data

Close method
Depth property
Dispose method
FieldCount property
GetBoolean method
GetByte method
GetBytes method
GetChar method
GetChars method
GetDataTypeName method
GetDateTime method
GetDecimal method
GetDouble 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 method
GetValues method
IsClosed property
IsDBNull method
Item property
NextResult method
Read method
RecordsAffected property