Interested to Buy Any Domain ? << Click Here >> for more details...
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
If a table contains 20000 records. In a page at each time 100 records to be displayed.
How will you fill the gridview by using datatable object at runtime?
Can we do database operations without using any of the ado.net objects?
What are the advantages using ado.net?
What is an example of ordinal data?
How does entity framework work?
What is the difference between Command and CommandBuilder object?
What is connection in ado.net?
What is the difference between an ADO.NET Dataset and an ADO Recordset?
What is ole used for?
What is ado control?
Which control of the BindingNavigator returns the current position within the data source?
What do you know about ADO.NET's objects and methods?
How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?
How to work with disconnected data - the dataset and sqldataadapter?
