What is the difference between DataTable , DataSet and Datagridview ?

Question

2.00/5 (4 votes)

See more:

Hello ,
I started to self study and stumbled upon "DataTable", "DataSet" and "DataGridView". I would like to know the difference between these three and how these three are related.?

Posted 5-Jun-11 22:24pm

asjadazeez

Add a Solution

Comments

Sergey Alexandrovich Kryukov 6-Jun-11 15:34pm

What's the difference between apple and Apple? Invalid question, at least in its form.
--SA

6 solutions

Solution 6

SQL

A dataset is an in-memory representation of a database-like structure. It can have one or more datatable and define relations between them, key field etc.
A datatable is an in-memory representation of a single database table. You can think of it as having columns and rows in the same way.
A dataview is a view on a datatable, a bit like a sql view. It allows you to filter and sort the rows - often for binding to a windows form control.

Posted 28-Jul-11 1:50am

Mastermanoj

Solution 1

A Practical Guide to .NET DataTables, DataSets and DataGrids - Part 4[^]

Posted 5-Jun-11 22:30pm

Monjurul Habib

Comments

Sergey Alexandrovich Kryukov 6-Jun-11 15:35pm

Good reading, my 5.
--SA

Monjurul Habib 6-Jun-11 15:59pm

thank you.

Solution 2

hi.

try this links below.

dataset class
data grid
data table

hope it helps.
goodluck. :)

-chaosgray-

Posted 5-Jun-11 22:35pm

chaosgray

Solution 4

DataSet is in-memory representation of database (has views, tables, relations etc) whereas DataTable is in-memory representation of a "database table".
Whereas DataGridView is a control to display data to the user.

Posted 5-Jun-11 22:57pm

RakeshMeena

Solution 5

dataset is front end memory by using dataset we can get data from backend
and fill into DataAdapter.

Datatable is also same purpose like dataset but it use ful in runtime very much

datagridview useful to get data in table format.

See the following code

C#

sqldataadapter da= new SqlDataAdater("select * from Employee", con);
DataSet ds = new DataSet();
da.Fill(ds);
datagridview1.DataSource = ds.table[0];

C#

sqldataadapter da = new SqlDataAdater("select * from Employee", con);
DataTable dt = new DataTable();
da.Fill(dt);
datagridview1.DataSource = dt;

Posted 5-Jun-11 23:05pm

kranthi.oru

Updated 5-Jun-11 23:33pm

v2

Comments

Uday P.Singh 6-Jun-11 5:54am

my dear friend, I don't think we fill Data adapter with Data set, in fact we fill Dataset with Data adapter. Data Adapter acts as a bridge between Database and Dataset. Data adapter works in a disconnected architecture.

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)

Prerak Patel · Accepted Answer · 2011-06-05T22:35:00

Solution 3

DataGridView is a control which gets data from DataTable, DataView or Dataset.
DataTable is an in-memory table.
DataSet is a collection of DataTable objects.

Posted 5-Jun-11 22:35pm

Prerak Patel

Comments

beginner in C#.net 6-Jun-11 5:45am

gud explanation... my 5

Monjurul Habib 6-Jun-11 12:25pm

nice answer my 5.

Sergey Alexandrovich Kryukov 6-Jun-11 15:35pm

Short and encouraging to learn them, my 5.
--SA