Can someone tell me differences between datareader and dataset

Question

Rajanikant Hawaldar · Answer

A dataset is sort of a collection of table elements loaded on memory. Data reader is more of a stream reader that reads from connections. There's something good about using datareaders, because it can be very efficient, since it will bring one line at a time while you're reading it. While a dataset contains all data in one place. But using a dataset, you don't necessarily need a connection to be set, also, you have so many features like serialization and relationships... but at a greater cost of resources. So, keep it in mind while using datasets. Also, dataset is for disconnected approach and datareader is for connected approach. There are tons of articles explaining that, but I hope it could clear the things a bit.

Sachin Singh · Answer

please follow my article, and you will be an ADO.NET expert. https://www.sharpencode.com/article/ADONET/dataset-and-sqldataadapter for now, the main difference is DataReader needs an open and active connection throughout while reading data from the database. But, DataSet along with DataAdapter represents a disconnected data access scenario where your data are filled in a Dataset that is in-memory and thereafter you don't need an open connection and yet you can manipulate data inside the dataset later you can commit all those changes that you made to the dataset to the database.again by opening a connection.

Ganesan C · Answer

DataReader The ADO.NET DataReader is used to retrieve read-only (cannot update data back to a datasource) and forward-only (cannot read backward/random) data from a database. Using of a DataReader increases application performance and reduces system overheads. This is due to one row at a time is stored in memory. //opening connection is must conn.open(); string SQLquery = "SELECT CustomerID, CompanyName FROM dbo.Customers"; SqlCommand cmd = new SqlCommand(SQLquery, conn); // Call ExecuteReader to return a DataReader SqlDataReader myReader = cmd.ExecuteReader(); //The Read method of the DataReader object is used to obtain a row from the results of the executed query. while(myReader.Read()) { Console.WriteLine("	{0}	{1}", myReader.GetInt32(0), myReader.GetString(1)); } //Once you're done with the data reader, call the Close method to close a data reader: myReader.Close(); //close the connection conn.close(); DataSet The DataSet is a in-memory representation of data. It can be used with multiple data sources. That is A single DataSet can hold the data from different data sources holdng data from different databases/tables. The DataSet represents a complete set of data including related tables, constraints, and relationships among the tables. string SQLquery = "SELECT CustomerID, CompanyName FROM dbo.Customers"; // create DataSet that will hold your Tables/data DataSet ds = new DataSet("CustomerDataSet"); //Create SqlDataAdapter which acts as bridge to put the data in DataSet,(data is table available by executing your SQL query) SqlDataAdapter myAdapter = new SqlDataAdapter(SQLquery, conn); //fill the dataset with the data by some name say "CustomersTable" myAdapter.Fill(ds,"CustomersTable");

Rijwan Ansari · Answer

In simple term Dataset - load the tables data and does not hold connection to database. Datareader - It holds connection to database and load data from the connection

Abhishek Chadha · Answer

Refer to below article you will get the detailed difference between these- https://www.c-sharpcorner.com/blogs/difference-between-datareader-dataset-dataadapter-and-datatable-in-c-sharp1 https://www.c-sharpcorner.com/uploadfile/61b832/datareader-vs-dataset/

Srinivasan Ramamoorthi · Answer

Check this article https://www.webcodeexpert.com/2013/04/15-main-difference-between-dataset-and.html?m=1

Vinitha T · Answer

DataReader is used to retrieve read-only and forward-only data from a database. It read only one row at a time and read only forward, cannot read backward/random. DataReader cannot update/manipulate data back to database. It retrieve data from single table. As it is connected architecture, data is available as long as the connection exists. DataSet is in-memory tables. It is disconnected architecture, automatically opens the connection and retrieve the data into memory, closes the connection when done. It fetches all the data at a time from the datasource to its memory. DataSet helps to fetch data from multiple tables and it can fetch back/forth/randomly.DataSet can update/insert/manipulate data.