DataSet in ADO.NET

Rajesh Kumar

15y2.1kLearn iOS Programming

Hi

What is the role of DataSet in ADO.NET?

6 Replies

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

Sam Hobbs15y ago
Yes, a DataSet can contain relations; the documentation is very clear about that. Anyone that wants to understand DataSets should read the documentation.

Note that I meant to add to what Pravin said, since a DataSet can contain data from many possible sources, not just ResultSets of a SqlCommand or Adapter.
0
Satyapriya Nayak15y ago
Hi Rajesh,

Dataset:- It is a disconnected ,Cached set of records.It may be called as a virtual database which contains tables,rows,columns.It is of two types
Typed dataset and untyped dataset

Typed dataset:- It has an associated xml schema.We can insert additional columns in the typed dataset.
Untyped dataset:- It doesnot have an associated xml schema.We cannot insert additional columns here.

Thanks
0
Mahesh Chand15y ago
As Prabhu said, a DataSet is a container that can take data and store within. It has capabilities of storing data in a relational structure and hence can store multiple database tables and their relationships.
0
Sam Hobbs15y ago
A DataSet is essentially a collection of tables. The tables can come from multiple places; they can come from a XML file, a database, a SQL query, or a program can create the tables during excution or they can come from other things.
0
Prabhu Raja15y ago
Hi,

The ADO.NET Dataset is a memory-resident representation of data that provides a consistent relational programming model regardless of the source of the data it contains. A DataSet represents a complete set of data including the tables that contain, order, and constrain the data, as well as the relationships between the tables.

For more refernce : http://msdn.microsoft.com/en-us/library/ss7fbaez(v=vs.80).aspx

Thank You
0
Pravin More15y ago
Hi Rajesh,
               Role of DataSet is to store multiple resultsets in the form of tables.......because many times your SqlCommand or Adapter returns multiple result set so we can store it in DataSet and fetch it one by one ............
    e.g
                             SqlDataAdapter ad = new SqlDataAdapter("SELECT * FROm Categories",myConnection);

                                                DataSet ds = new DataSet();

                                                ad.Fill(ds,"Categories");

                                                DataTable dt = ds.Tables["Categories"];

Thanx,hope it will help you.
Pravin
0