ExecuteReader(CommandBehavior) method

Executes a SQL statement that returns a result set.

Syntax
Visual Basic

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

public SADataReader 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 SADataReader object.

Remarks

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