What is a DataReader object?

Posted By: Avi

Date: 6 October 2009 05:35:46 AM

Answer:

DataReader object provides a read-only, forward-only stream of data from a database. The DataReader object is designed for connected scenarios and offers better performance than reading data into a DetaSet object.But DataReader object does not persist contents as in DataSet object.
Posted By: eTechPlanet	Date: 6 October 2009 05:35:46 AM
The DataReader object provides a forward-only, read-only, connected stream recordset from a database. Unlike other components of the Data Provider, DataReader objects cannot be directly instantiated. Rather, the DataReader is returned as the result of the Command object's ExecuteReader method. The SqlCommand.ExecuteReader method returns a SqlDataReader object, and the OleDbCommand.ExecuteReader method returns an OleDbDataReader object. The DataReader can provide rows of data directly to application logic when you do not need to keep the data cached in memory. Because only one row is in memory at a time, the DataReader provides the lowest overhead in terms of system performance but requires the exclusive use of an open Connection object for the lifetime of the DataReader.
Posted By: Johndecruse	Date: 4 February 2010 12:52:10 AM