Nupur Bansal
What is difference between DataSet and DataTable?
Posted by Nupur Bansal in ADO.NET on Nov 07, 2012
  • 0
  • 2
  • 7136
Do you know the answer for this question? Post it below.
Posted by sapana sharma on Dec 01, 2014
  • 2

Data Table:
1. A DataTable is an in-memory representation of a single database table which has collection of rows and columns.
2.DataTable fetches only one TableRow at a time
1.A DataSet is an in-memory representation of a database-like structure which has collection of DataTables.
2.DataSet can fetch multiple TableRows at a time

Posted by Nitish kumar on Nov 20, 2012
  • 0


1. Its connectionless. whenever you want fetch data from database. its connects indirectly to the database and create a virtual database in local system. then disconnected from database.

2. Its easily read and write data from virtual database.



A DataTable object represents a single table in the database. It has a name rows and columns.

There is not much difference between dataset and datatable, dataset is just the collection of datatables.