Difference between dataset and data table

Question

2.80/5 (5 votes)

See more:

DataTable

What is the different between dataset and data table.with suitable examples

Posted 14-Mar-11 0:41am

Ajay Lanjewar

Add a Solution

Comments

Albin Abel 14-Mar-11 6:48am

dataset is container of datatables. It is like your team and you in that. What you mean by difference? Then it is like what is difference between your team and you

Sergey Alexandrovich Kryukov 14-Mar-11 15:21pm

The questions in the format "what's the different between {0} and {1}?" can not be correct in principle. In my opinion, they should not be answered.
--SA

Member 14107736 1-Jun-20 6:29am

nice

3 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)

OriginalGriff · Answer 1 · 2011-03-14T00:47:00

Solution 1

A DataSet holds one or more DataTables.

Example 1:

DataTable dt = new DataTable();
DataSet ds = new DataSet();
ds.Tables.Add(dt);

Example 2:

DataTable dt1 = new DataTable();
DataTable dt2 = new DataTable();
DataSet ds = new DataSet();
ds.Tables.Add(dt1);
ds.Tables.Add(dt2);

If you want any more, then do your own homework.

Posted 14-Mar-11 0:47am

OriginalGriff

Comments

Sergey Alexandrovich Kryukov 14-Mar-11 15:22pm

Griff, I did not vote this time. Why putting yourself in cumbersome position answering questions which are incorrect by definition? Please see my comment to the Question.
--SA

Member 11382635 3-Mar-15 23:13pm

SAKryukov, How do you have time to become an expert contributor when you waste your time justifying to everyone how smart you are...thank you Griff.

Member 10470965 29-May-14 10:30am

Thanks for taking the time to answer the question clearly and precisely. Not everyone who comes here seeking wisdom and knowledge is an expert in programming C#. It would be a shame to cut people like myself from those of you gentle people who have vast amounts knowledge and experience. We, the unwashed, are looking for answers to what may seem like trivial questions. That is how we got here in the first place. Google is a our friend, most of the time.

OriginalGriff 29-May-14 10:47am

You're welcome!

Sandeep Mewara · Answer 2 · 2011-03-14T00:52:00

Solution 2

One line:
DataSet is collection of DataTables.

Above line itself is more than enough to explain what are they and where to use. Right?

In case not, then:
DataTable = A table with rows and columns
DataSet = A set with datatables. Can hold one or more Datatables in it. A container of datatables. Not just it, in Dataset you can have relations between tables too.

Refer to the documentation on MSDN to get more in detail:
Take a look here: DataSet[^] and DataTable[^]

Posted 14-Mar-11 0:52am

Sandeep Mewara

Comments

Sergey Alexandrovich Kryukov 14-Mar-11 15:23pm

Sandeep, I did not vote this time. Why putting yourself in cumbersome position answering questions which are incorrect by definition? Please see my comment to the Question.
--SA

Member 11382635 3-Mar-15 23:14pm

SAKryukov, How do you have time to become an expert contributor when you waste your time justifying to everyone how smart you are...thank you Sandeep.

Sergey Alexandrovich Kryukov 3-Mar-15 23:18pm

This post is based on some wrong assumptions. Any other ideas?
—SA

zablab 1-Jan-15 20:58pm

Great job Sandeep!

Member 11683956 · Answer 3 · 2015-05-12T23:12:00

::::Dataset:::

1) first of all Dataset is the disconnected architecture.

2) DataSet is a Class For storing a dataTable in it.

3) DataSet is a collection of DataTables which is having multiple rows and columns

4) DataSet contains Multiple Tables in it .. DataTable does't

5) DataSet is More flexible then DataTable

::::DataTable:::

1) DataTable also a Class Which contains multiple rows and columns in it..

2) DataTable Stores only one table in it.

3) DataTable have a GetTable() method for getting table in database.

4) DataTable is less flexible then DataSet

Thank You

Difference between dataset and data table

3 solutions

Solution 1

Solution 2

Solution 5

Add your solution here

Preview 0

Existing Members

...or Join us