What is the difference between a DataReader and a DataSet?

Hi Sapna,

It is very much asked question so far.

There are lots of differences and you can choose any of them according to your use.

The difference given above by friend is one point.

Now See..

DataSet : -

It means set of data (Tables) --->

So it takes time to fill whole data.And you cannot access data before fully filled.

It uses "DataReader" internally to fill the datas.

Consist set of queries so Lot Memory and less performance.

So sometime bad while loading or using in ASP.Net pages.

Best while passing whole datas to any services.

----------------------------------------

DataReader

You can print datas while reading each lines from database.

Stores one result at a time.

Faster less memory.

====================================

http://yuvadeveloper.blogspot.com

2 Answers