Diff B/W DataSet vs DataTable

Categories >> Software >> Microsoft Related >> ADO.NET
Suggest New Category

Question Posted / chanchal

6 Answers
10176 Views
Star Wire, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Diff B/W DataSet vs DataTable..

Answer / ruchi

A dataset can hold the data of multiple tables, whereas
data table can have only one table's data.

Is This Answer Correct ?

42 Yes

3 No

Diff B/W DataSet vs DataTable..

Answer / pranshu sharma

DataSet objects contains multiple DataTable objects.

Is This Answer Correct ?

26 Yes

4 No

Diff B/W DataSet vs DataTable..

Answer / ajay singh negi

Dataset is a collection of tables, which is used in
disconnected architecture.generally to fill dataset we use
fill method of dataadapter. datatable is just like table
which has columns and rows.
or
A DataSet is an in memory representation of data,It
containing one or more DataTables.
A DataTable is an in-memory representation of data,
typically retrieved from a database or XML source.

Is This Answer Correct ?

13 Yes

3 No

Diff B/W DataSet vs DataTable..

Answer / bharat pandey

The Best Difference between data table and dataset is that
the DataSet is serialized data source whereas datatable is
not. That is why web services can always returns dataset as
the result but not the datatables. All of the above answers
are childish and they can destroy your interview in just a
sec. when you answer those.

Is This Answer Correct ?

7 Yes

0 No

Diff B/W DataSet vs DataTable..

Answer / sandyni

A DataSet is an in memory representation of data,It
containing one or more DataTables.

A DataTable is an in-memory representation of data,
typically retrieved from a database or XML source and that
can hold only one table data

Is This Answer Correct ?

6 Yes

0 No

Diff B/W DataSet vs DataTable..

Answer / umarali1981

DataTable:

1.Meaning: A DataTable is an in-memory representation of a
single database table which has collection of rows and columns

2.Number of rows retrieved at a time:DataTable fetches only
one TableRow at a time

3.Provision of DataRelation Objects:As DataTable is a single
database table, so there is no DataRelation object in it.

4.Enforcing Data Integrity:In DataTable, there is no
UniqueConstraint and ForeignKeyConstraint objects available.

5.DataSource can be Serialized or Not:In DataTable,
DataSource cannot be serialized.

6.To know the example for DataTable, please try the URL:

http://www.dotnetperls.com/datatable

DataSet:

1.Meaning:A DataSet is an in-memory representation of a
database-like structure which has collection of DataTables.

2.Number of rows retrieved at a time:DataSet can fetch
multiple TableRows at a time

3.Provision of DataRelation Objects: In DataSet, DataTable
objects can be related to each other with DataRelation objects.

4.Enforcing Data Integrity:In DataSet, data integrity is
enforced by using the UniqueConstraint and
ForeignKeyConstraint objects.

5.DataSource can be Serialized or Not:DataSet is serialized
DataSource .That is why web services can always returns
DataSet as the result but not the DataTables.

6.To know the example for DataSet, please try the URL:
http://www.dotnetperls.com/dataset

Reference:
http://onlydifferencefaqs.blogspot.in/2012/08/difference-between-datatable-and-dataset.html