Answer Posted / 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
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What does ado stand for?
What is namespace in ado.net?
What are different layers of ADO.Net?
What is the use of sqldatareader class?
Which is faster entity framework or ado.net?
how we can fire event in databound coulm in datagfrid withot using button?
What are the major challenges in accessing data from a database?
What is the use of SqlCommand object?
What is ole in vb?
Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?
What are the 3 major types of connection objects in ado.net?
What two types of data providers does ADO.NET supply? What determines which one you should use?
What are the difference between readonly vs. Const?
What is ado full form?
Define the executescalar method?
