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

Syntax

Visual Basic

Public NotInheritable Class SADataReader 
  Inherits DbDataReader
  Implements IListSource

C#

public sealed class SADataReader : DbDataReader,
  IListSource

Remarks

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: IDataReader,  IDisposable,  IDataRecord,  IListSource

For more information, see Accessing and manipulating data.

See also

• SADataReader members
• ExecuteReader() method