when to use dataset,datareader

Question

when to use dataset,datareader. i am working in Ecommerece application

Raja T · Answer

Hi Vasu, It is It depends on your needs. DataReader: It is Connection oriented. One of the most important differences is that a DataReader will retain an open connection to your database until you're done with it while a DataSet will be an in-memory object. If you bind a control to a DataReader then it's still open. In addition, a DataReader is a forward only approach to reading data that can't be manipulated. DataSet :It is Disconnecttion oriented. With a DataSet you can move back and forth and manipulate the data as you see fit. Some additional features: DataSets can be serialized and represented in XML and, therefore, easily passed around to other tiers. DataReaders can't be serialized. On the other hand if you have a large amount of rows to read from the database that you hand off to some process for a business rule a DataReader may make more sense rather than loading a DataSet with all the rows, taking up memory and possibly affecting scalability. http://stackoverflow.com/questions/1083193/whats-better-dataset-or-datareader http://www.codeproject.com/Articles/420217/DataSet-vs-DataReader

Sekhar Babu · Answer

It depends on your needs. When you are working large amount of data more than 10000 then datareader is best, but it requires a open connection and it is forward only and read only , fetched can not be manipulated. When you are dealing with small amounts and you want to manipulated fetched data go for dataset, it doesn't require open connection, data can be serialized etc Check this for more info http://stackoverflow.com/questions/1083193/whats-better-dataset-or-datareader

sikander shaikh · Answer

ok

Sumit Joshi · Answer

Hi Vasu, Thanks buddy. If found helpful Mark as Correct Answer.

Upendra Pratap Shahi · Answer

Your welcome Vasu T , Kindly accept the answer .

Vasu T · Answer

THank you

Sandeep Kumar · Answer

It really depends on the sort of data you're bringing back. Since a DataSet is (in effect) just a collection of DataTable objects, you can return multiple distinct sets of data into a single, and therefore more manageable, object. Performance-wise, you're more likely to get inefficiency from unoptimized queries than from the "wrong" choice of .NET construct. If you execute just select on your queries, you can use ExecuteDataReader in order to increase your performance. Link MSDN about performance report : http://msdn.microsoft.com/en-us/library/ms978388.aspx

Upendra Pratap Shahi · Answer

DataReader 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. To bind DataReader data to GridView we need to write the code like as shown below: Protected void BindGridview() { using (SqlConnection conn = new SqlConnection( "Data Source=abc;Integrated Security=true;Initial Catalog=Test" )) { con.Open(); SqlCommand cmd = new SqlCommand( "Select UserName, First Name,LastName,Location FROM Users" , conn); SqlDataReader sdr = cmd.ExecuteReader(); gvUserInfo.DataSource = sdr; gvUserInfo.DataBind(); conn.Close(); } } Holds the connection open until you are finished (don't forget to close it!). Can typically only be iterated over once Is not as useful for updating back to the database DataSet DataSet is a disconnected orient architecture that means there is no need of active connections during work with datasets 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. protected void BindGridview() { SqlConnection conn = new SqlConnection( "Data Source=abc;Integrated Security=true;Initial Catalog=Test" ); conn.Open(); SqlCommand cmd = new SqlCommand( "Select UserName, First Name,LastName,Location FROM Users" , conn); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); gvUserInfo.DataSource = ds; gvUserInfo.DataBind(); } DataAdapter DataAdapter will acts as a Bridge between DataSet and database. This dataadapter object is used to read the data from database and bind that data to dataset. Dataadapter is a disconnected oriented architecture. Check below sample code to see how to use DataAdapter in code: protected void BindGridview() { SqlConnection con = new SqlConnection( "Data Source=abc;Integrated Security=true;Initial Catalog=Test" ); conn.Open(); SqlCommand cmd = new SqlCommand( "Select UserName, First Name,LastName,Location FROM Users" , conn); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); gvUserInfo.DataSource = ds; gvUserInfo.DataBind(); } Lets you close the connection as soon it's done loading data, and may even close it for you automatically All of the results are available in memory You can iterate over it as many times as you need, or even look up a specific record by index Has some built-in faculties for updating back to the database. DataTable DataTable represents a single table in the database. It has rows and columns. There is no much difference between dataset and datatable, dataset is simply the collection of datatables. protected void BindGridview() { SqlConnection con = new SqlConnection( "Data Source=abc;Integrated Security=true;Initial Catalog=Test" ); conn.Open(); SqlCommand cmd = new SqlCommand( "Select UserName, First Name,LastName,Location FROM Users" , conn); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); gridview1.DataSource = dt; gvidview1.DataBind(); } Go through below link- http://www.c-sharpcorner.com/Blogs/12509/difference-between-datareader-dataset-dataadapter-and-data.aspx Kindly accept the answer.

Sumit Joshi · Answer

Hi Vasu, In my openion Datasets are used when we want to handle each aspect of data using C# Language ie. Table relations, data specification etc in this approach all tables of database are maintained by using programming language but datareader are used when all operations are dependent on Satabase ie. SQL Server. For more details Exlore MSDN Thanks buddy. If found helpful Mark as Correct Answer.