Difference Between DataSet and DataTable

         

Difference Between DataSet and DataTable



               DataSet                   DataTable
1
DataSet can fetch multiple TableRows at a time.
DataTable fetches only one TableRow at a time.
2
A DataSet is like structure which has collection of DataTables.
A DataTable is  a single database table which has collection of rows and columns.
3
DataSet, DataTable objects can be related to each other with DataRelation objects.
DataTable is a single database table, so there is no DataRelation object in it.
4
DataSet is serialized DataSource .
DataTable, DataSource cannot be serialized.
5
DataSet, data integrity is enforced by using the Unique Constraint and ForeignKeyConstraint objects.
DataTable, there is no Unique Constraint and ForeignKeyConstraint objects available.











0 comments:

Post a Comment