latest Post

Difference Between DataSet and DataTable in SQL Server

DataSet:  

DataSet can fetch multiple TableRows at a time.

A DataSet is like structure which has collection of DataTables.

DataSet, DataTable objects can be related to each other with DataRelation objects.

DataSet is serialized DataSource .

DataSet, data integrity is enforced by using the Unique Constraint and ForeignKeyConstraint objects.

DataTable:

DataTable fetches only one TableRow at a time.

A DataTable is  a single database table which has collection of rows and columns.

DataTable is a single database table, so there is no DataRelation object in it.

DataTable, DataSource cannot be serialized.

DataTable, there is no Unique Constraint and ForeignKeyConstraint objects available.


follow us on facebook

:
https://www.facebook.com/dotnettuts

About Mallikarjun A

Mallikarjun A
Recommended Posts × +

0 comments:

Post a Comment