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) » SACommand class » ExecuteReader methods


ExecuteReader(CommandBehavior) method

Executes a SQL statement that returns a result set.

Visual Basic

Public Function ExecuteReader( _
   ByVal behavior As CommandBehavior _
) As SADataReader

public SADataReader ExecuteReader(
   CommandBehavior behavior
  • 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 SADataReader object.


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

See also