Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is the difference between a DataReader and a DataSet?

April 26, 2017datareader dataset difference

0

10 Posted

What is the difference between a DataReader and a DataSet?

1 Answer

0

10 Posted

DataReader 1. DatReader works on a Connection oriented architecture. 2. DataReader is read only, forward only. It reads one record at atime. After DataReader finishes reading the current record, it moves to the next record. There is no way you can go back to the previous record. So using a DataReader you read in forward direction only. 3. Updations are not possible with DataReader. 4. As DataReader is read only, forward only it is much faster than a DataSet. DataSet 1. DataSet works on disconnected architecture. 2. Using a DataSet you can move in both directions. DataSet is bi directional. 3. Database can be updated from a DataSet. 4. DataSet is slower than DataReader.