DataReader is a class that holds data as rows and coloums to access data from the DataReader.

It provides the following methods:

1. GetName(int ColIndex) - The return type of this method is a string, it returns the name of the column for the given index position.

2. Read() - Moves the Record Pointer from the current location to the next row and returns a Boolean status that tells whether the row to which we have moved contains data in it or not, that will be true if present or false if not present.

3. GetValue(int Colindex) - Returns a column's value from the row to which the pointer was pointing by specifying the column index position.

4. NextResult () - Moves the record pointer from the current table to the next table if a table exists and returns true else returns false.

Features of Data Reader:

1. Provides faster access to data from a Data Source, since it is connection oriented.

2. It can hold multiple tables at a time. To load multiple tables into a DataReader pass multiple select statements as the argument to the command separated by a colon (;).

For example:

1. Command cmd=new Command(“Select * From Student ; Select * From Mark ”, Con);

2. Data Reader dr= cmd.ExecuteReader();   _{Your Comment}