What is the role of the DataReader class in ADO.NET connections?

Basic role of Datareader has been provided below....


DataReader returns read-only, forward-only rowset from the data source.
A DataReader provides fast access when a forward-only sequential read is needed.

DataReader classes are connected to their data sources. Consequently, there is no generic DataReader class. Rather, each managed provider exposes its own DataReader class, which implements the System.Data.IDataReader interface. The SQL Server managed provider exposes the SqlDataReader class (in the System.Data.SqlClient namespace). DataReader classes provide sequential, forward-only, read-only access to data. Because they are optimized for this task, they are faster than the DataSet class.


Example

OleDBConnection myConnection =
new OleDBConnection(@"Provider=Microsoft.Jet.OLEDB.4.0 ;" +
@"Data Source=C:\Test.MDB");

// open connection
myConnection.Open();