why to use datatable when dataset is doing the same thing.

Question

1.00/5 (1 vote)

See more:

My question is why do we use datatable when we have dataset which provides same functionality like datatable . Also its functionality is very vast(dataset). we can bind dataset to gridview than why to use datatable. Also we say that datatable,dataset,datareader represents an inmemory database so does it mean that that database tables store in our pc (physical disc) . What if we dont have sql server on our pc and using an application(web) that sends us tables(say 4)from physical storage database than in what format do the tables store.

Posted 20-Aug-13 19:08pm

Rambo_Raja

Add a Solution

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)

Mehdi Gholam · Answer 1 · 2013-08-20T19:13:00

Solution 1

DataSet is a collection of DataTables, so they are not the same thing.

Yes you can use a DataSet as an in-memory database on your clients, however it is :
* not multiuser
* slow on loading
* can be memory hogging

Posted 20-Aug-13 19:13pm

Mehdi Gholam

Comments

Thanks7872 21-Aug-13 1:18am

Excellent. To the point. ↑voted.Added some more with below answer.

Mehdi Gholam 21-Aug-13 1:21am

Thanks Rohan!

Rambo_Raja 21-Aug-13 1:23am

what does dataset is "not multiuser" implies?

Mehdi Gholam 21-Aug-13 1:29am

Changes in your dataset will not show in other computers.

Rambo_Raja 21-Aug-13 1:34am

u mean to say that the changes in datatable reflects in other computer??

Mehdi Gholam 21-Aug-13 1:41am

Yes.

Thanks7872 · Answer 2 · 2013-08-20T19:18:00

Solution 2

Refer these links

Difference between dataset and data table[^]

What is the difference between DataTable and DataSet?[^]

DataSets, DataTables, and DataViews[^]

Regards..:)

Posted 20-Aug-13 19:18pm

Thanks7872

Comments

Mehdi Gholam 21-Aug-13 1:21am

5'ed

Thanks7872 21-Aug-13 1:23am

Thanks Mehdi.

PIEBALDconsult · Answer 3 · 2013-08-20T19:27:00

DataSets can hold several DataTables and also the relationships between them -- if you need that, you need a DataSet; if you don't need that, you don't need a DataSet.

"represents an inmemory database" -- I never need that.

I very rarely use a DataSet, they are too heavy for what I do. I use DataTables sometimes, but DataReaders quite a bit.

And you can bind a DataTable to a DataGridView and other controls as well.