Contents Index ExecuteNonQuery method ExecuteScalar method

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

ExecuteReader method


Description 

Executes a SQL statement that returns a result set.

Syntax 1 

AsaDataReader ExecuteReader( )

Syntax 2 

AsaDataReader ExecuteReader( CommandBehavior behavior )

Parameters 

behavior    One of CloseConnection, Default, KeyInfo, SchemaOnly, SequentialAccess, SingleResult, or SingleRow.

For more information about this parameter, see the .NET Framework documentation for CommandBehavior Enumeration.

Return value 

The result set as an AsaDataReader object.

Usage 

The statement is the current AsaCommand object, with CommandText and Parameters as needed. The AsaDataReader object is a read-only, forward-only result set. For modifiable result sets, use an AsaDataAdapter.

See also 

AsaDataReader class

AsaDataAdapter class


Contents Index ExecuteNonQuery method ExecuteScalar method