What is Difference between dataset and Datareader

gajanan yandarkar

8y974Learn iOS Programming

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P8y ago
hi,

DataSet is a disconnected architecture that means there is no need of active connections and it is a collection of DataTables and relations between tables. It is used to hold multiple tables with data. You can select data form tables, create views based on table and ask child rows over relations. Also DataSet provides you with rich features like saving data as XML and loading XML data.

DataReader is used to read the data from database and it is a read and forward only connection oriented architecture during fetch the data from database. DataReader will fetch the data very fast when compared with dataset. Generally we will use ExecuteReader object to bind data to datareader
Sanwar Ranwa8y ago
Best answer is Here

http://net-informations.com/faq/ado/dataset-datareader.htm

https://www.c-sharpcorner.com/blogs/difference-between-datareader-dataset-dataadapter-and-datatable-in-c-sharp1

https://www.c-sharpcorner.com/blogs/difference-between-dataset-and-datareader1
Manav Pandya8y ago
Hello

For complete reference with code snippet [Example] , follow few links given below :

https://www.c-sharpcorner.com/blogs/difference-between-datareader-dataset-dataadapter-and-datatable-in-c-sharp1

https://www.c-sharpcorner.com/blogs/difference-between-datareader-dataset-datatable-and-dataadapter-in-asp-net1

https://www.c-sharpcorner.com/uploadfile/61b832/datareader-vs-dataset/

Thanks
Ramesh Palanivel8y ago
Hi gajanan,

refer the below link, you will get some idea about it.

http://net-informations.com/faq/ado/dataset-datareader.htm