what is DataSet and DataTable in C#

Question

0.00/5 (No votes)

See more:

I want to know about dataset and datatable.

where and why i will use dataset or datatable. which one is best and why.

I have search in goolge. But finding lot of things.
Can any one discuss it in easy way.

Thanks in advance.

Posted 20-Feb-11 1:18am

Rasadul Alam Rashed

Add a Solution

4 solutions

Solution 3

While it is not, by any imagination, the most complete set, I like to refer to the documentation on MSDN to get the gist of what represents, how do I use it, what are the methods it supports etc...

Take a look DataSet[^] , DataTable[^]

Posted 20-Feb-11 5:12am

Yusuf

Solution 2

The above answer cent per cent rigth

DataTable is a single Table containing row and columns

and DataSet is kind of a container of DataTables, which can have many DataTables, and each DataTable is DataSet can be identified by its zero-based index or string name.

C#

DataSet ds;

ds.Tebles[0] 

or

ds.Tables["tablename"]

Posted 20-Feb-11 4:55am

dontumindit

Comments

Albin Abel 20-Feb-11 11:38am

This is an repeatable of Sandeep's answer. Anyhow dataset is not only container of datatable, it also holds collection of relationships. Simply it is a disconnected (miniature?) of the database. You can do most of the op with dataset that you can do with database. Additionally it talk with database with an adapter. This Adapter pattern helps the dataset not dependent to a particular kind of database, but at runtime it can bind to any kind of DB, sqlserver or mySql....So that is the use of an adapter pattern. Only slight dependency would be then the structure of the dataset and the database. This way the dataset survives independently (disconnected) and talk to database whenever necessary at runtime, the adapter fits the thumb drive into the correct socket... excuse me for talking long.

Solution 5

Q.when a collection of data is returned from a strored procedure,does it automatically goes inside the dataset?can i retrive it directly by making object of dataset?

Posted 10-Jul-15 8:35am

Member 11774452

Comments

[no name] 10-Jul-15 14:41pm

Exactly how is this a solution to this 4 year old question?

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)

Sandeep Mewara · Accepted Answer · 2011-02-20T01:32:00

Solution 1

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.

Posted 20-Feb-11 1:32am

Sandeep Mewara

Comments

Espen Harlinn 20-Feb-11 7:34am

My 5 - odd question comming from a Senior Engineer, Software

Sandeep Mewara 20-Feb-11 7:36am

Is that so. Surely strange then!

BTW, thanks Espen. :)

OriginalGriff 20-Feb-11 7:37am

You think he might have *lied* on his Professional Profile! Shock! :laugh:

Sandeep Mewara 20-Feb-11 13:32pm

Shock now!!!

[no name] 20-Feb-11 13:28pm

Mr Espen what type of answer it is?? I know about this. But i want to know both them deeply. I want to know which one is faster with quary.

Sandeep Mewara 20-Feb-11 13:32pm

Oh! You still have doubts.

Dude, dataset is collection of datatable. So obviously, if a particular work can be done via just a single table then you should go with Datatable and avoid Dataset as it would just add a wrapper to single table with some additional features specific to dataset.

In case you are returing some data/few tables from a stored procedure then you *cannot* go with a datatable and *have* to go with dataset which can have multiple tables in it.

Not just it, in Dataset you can have relations between tables too.

So, if you just want to know from performance prospective and not feature wise, then Datatables has to be better than dataset (just by definition!).

Clear now?

Espen Harlinn 20-Feb-11 14:29pm

If you really want to create "optimal" solutions in terms of speed and flexibility, DataSet and DataTable probably isn't your best choice. There are some very good tools available both commercially and here on codeplex that provide a much better solution - orm, or orm like depending on your definition.

If you really want to gain insight into DataSet and DataTable -
download and install the source code from http://referencesource.microsoft.com/netframework.aspx
and then there is mono - source available at http://ftp.novell.com/pub/mono/sources/

More than anything this will allow you to learn about .Net - and you'll be able to decide for yourself why something is appropriate or not based on facts.

BTW: I looked through all your questions before making my remark ...

Albin Abel 20-Feb-11 11:27am

hmm, so he hasn't used dataset yet. May be he was used to other languages like PHP, where there is no concept of connected and disconnected arch, not sure. my 5 for the clear cut answer

fjdiewornncalwe 20-Feb-11 15:07pm

Albin: The OP has been asking C# based questions for well over 8 months now, and he claims to be a "senior" level developer in his profile. For most of us here with loads of experience in the real world, that doesn't add up, which is the basis of Espin's comment. But you do make a good point if we didn't have this info, so kudos to you for the thought.