Hariharan

• Sep 13th, 2005

 

Data Reader is Read only version Data Set,Each record is returned as a Data Reader Object,ExecuteReader method acts directly on the database connection.

There are two versions of the data reader object:

OleDbDataReader and SqlDataReader.

Ali

• Jul 21st, 2006

 

Well, Dataset is used for distributed environment where the data source is often disconnected and is not available..so we fetch data and store it in memory..overhead on memory(consider each request having more than 1000 records and there are thousands of request..)But Datareader as said above is used for connected environment so it provides greater efficiency by direct menipulating the data at server...Hence it is used where DB server and application have reliable connected media...eg web..you dont need to hold 1000 records in memory in this case....

Helper

• Nov 2nd, 2007

 

Data Reader is used to go through the records in a particular order. It can be either forward order or backward order.

prashanthdd

 Profile Answers by prashanthdd 

• Apr 28th, 2008

 

DataReader is usefull when we need a foreward only sequential access in a better speed.