What is difference between DataTable and DataAdapter?

Question

DataSet is mainly used to fetch and hold the records for one or more tables into memory. A DataAdapter is used to populate DataSet from records returned from an SQL statement and also a DataSet can be created in memory and tables and data can be added to it.

What is difference between DataSet and DataReader and DataAdapter?

DataAdapter object is used to read the data from database and populates that data to DataSet whereas DataReader simply reads the data using the Read() method .

What is the difference between a DataTable and a DataReader?

Using a DataReader, you can access each column of the result set, read all rows of the set, and advance to the next result set if there are more than one. DataTable represents a single table in the database. It has rows and columns.

What is difference between DataTable and adopter?

4) As DataTable is a single database table, so there is no DataRelation object in it whereas In DataSet, DataTable objects can be related to each other with DataRelation objects. But In DataSet, data integrity is enforced by using the Unique Constraint and Foreign Key Constraint objects.

What is DataAdapter used for?

A DataAdapter is used to retrieve data from a data source and populate tables within a DataSet. The DataAdapter also resolves changes made to the DataSet back to the data source.

Expert · Answer