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
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.
search in google
C# Corner. All contents are copyright of their authors.