What is difference between DataSet and DataTable?

1

1

search in google

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 DataSet: 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

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 DataSet: 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

DataSet------> 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. ************************ DataTable-----------> 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.