Hello… Everyone
Any one can give me perfectly information about Dataset in c#. Why and where use it or is any substitute of Dataset in c#. How it's work in data source....
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Mamta MPosted Jul 6, 2011, 12:53 AM
Consider for example that you have Suppliers and Shipments tables from which you retrieve data frequently into a C# application. Instead of making 100's of round trips to the database server, you store data from these tables in a DataSet object which is stored locally and perform all your data manipulations on the DataSet object. When you want to submit changes back to the database, you can do that through the DataSet. Using a DataSet gives you faster and more efficient performance.
This link from MSDN describes more what is a dataset and what is its role in ADO.NET.
http://msdn.microsoft.com/en-us/library/ss7fbaez.aspx
Valon AdemiPosted Jul 6, 2011, 2:22 AM
Manish TewatiaPosted Jul 6, 2011, 2:17 AM
http://www.c-sharpcorner.com/UploadFile/jgodel/DataSetsOverview11232005041415AM/DataSetsOverview.aspx
Vilas GitePosted Jul 6, 2011, 2:09 AM
refer "Our recommended articles".
------------------------------------------------
Jiteendra SampathiraoPosted Jul 6, 2011, 1:28 AM
What mamta said is absolutely right...
refer these links for more clarification:
Link1
Link2
hope it helps....
Posted Jul 6, 2011, 1:08 AM
Dataset is an object which contains a set of datatables and u can access each datatables by ds.table[0].It is mainly used when u return results from a stored procedure which contains one or more datatables.
With Regards
P.Krishna Prasad