Using the DataReader Object : DataReader « ADO.net Database « ASP.NET Tutorial






  1. ASP.NET Tutorial
  2. ADO.net Database
  3. DataReader
DataReader represents the results of a database query. 
You get a DataReader by calling a Command object's ExecuteReader() method.
Verify whether a DataReader has any rows by checking the HasRows property or calling the Read() method. 
The DataReader represents a single row of data at a time. 
To get the next row of data, you need to call the Read() method. 
When you get to the last row, the Read() method returns False.








18.24.DataReader
18.24.1.Using the DataReader Object
18.24.2.Iterating Through A DataReader
18.24.3.Create DataReader object from SqlCommand
18.24.4.List Binding DataReader
18.24.5.Returning Multiple Resultsets
18.24.6.Working with Multiple Active Resultsets