when to use a dataset and when to use datareader

[phanimadhav]

Hello experts,
I have small query in ado.net.When we are using Dataset and when we are using Datareader.Actu ally these two are using getting the values from database.But which situation we are using Dataset and when we are using Datareader.Coul d you please help me.Thank you for ur advanced reply

[kenobewan]

There are many prior posts re this subject, suggest you search the site.

Depends on the requirements and how the data will be used.

[Frinavale]

You can use the DataSet class to retrieve a collection of DataTable objects that you can relate to each other with DataRelation objects. After filling the DataSet with data, you can edit this data (delete rows or anything) in memory...withou t accessing the DataBase. You can then cancel what the user's done, or update the database with the changes if you want to.


You can use the ADO.NET DataReader to retrieve a read-only data from a database.


Make sense?


-Frinny