What is difference b/w dataset and datatable pratacally

Question

1.00/5 (1 vote)

See more:

Actually i had access the data from database using disconnected architecture in ado.net

some code like as

C#

Dataset ds=new Dataset();

da.fill(ds)

we can write above code same as below but some difference there(concept is unique)

C#

DataTable dt=new DataTable();

da.fill(dt)

i want difference b/w dataset and datatable in this example.both concepts will work

i have doubt about dataset and datatable but you can use the these different

dataclasses in different situations

why should developers prefer the alternative class(datatable) in disconnected mode

how will works ? how the dataset and datatable will work.

please help me.

thank u

What I have tried:

i want difference b/w dataset and datatable in this example.both concepts will work

i have doubt about dataset and datatable but you can use the these different

dataclasses in different situations

why should developers prefer the alternative class(datatable) in disconnected mode

how will works ? how the dataset and datatable will work.

Posted 22-Jun-16 10:32am

Krishna Veni

Updated 22-Jun-16 20:00pm

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2016-06-22T10:38:00

Solution 1

In simplest terms, a DataSet is a collection of DataTable objects and their relationships (DataRelation).

DataTables are collections of records, pretty much mirorring the concept of a table in a database.

Posted 22-Jun-16 10:38am

Dave Kreskowiak

Karthik_Mahalingam · Answer 2 · 2016-06-22T18:20:00

Quote:
i want difference b/w dataset and datatable in this example.both concepts will work

If your Query or Stored procedure is returning a single table then you shall go for DataTable

C#

da.fill(dt)  // da - dataadapter , dt - datatable

If it returns multiple tables then use DataSet

C#

da.fill(ds) // da- dataadapter, ds - dataset

the number of table returned from the query/procedure will be assigned to the Number to DataTables inside the DataSet dynamically, which you can access the DataTable using the index of the table, as

C#

var table1  = ds.Tables[0]; // 1st Table
var table2 = ds.Tables[1]; // 2nd Table

for more info on theory part refer DataSet vs DataTable[^]

M.M.Mohseni · Answer 3 · 2016-06-22T13:49:00

Solution 2

You have to know if you are working with typed dateset and data adapter, datetable is a part of dateset object.

Posted 22-Jun-16 13:49pm

M.M.Mohseni

Maciej Los · Answer 4 · 2016-06-22T20:00:00

Solution 4

It has been already answered[^] several times[^].

Posted 22-Jun-16 20:00pm

Maciej Los