DataAdapter class in ADO.NET

Question

Explain about the DataAdapter class in ADO.NET.

Answer 1

DataAdapter class retrieves the data from the database, stores it in a dataset, and reflects the changes made within the dataset to the database. DataAdapter class acts as an intermediary for all the communication between the DataSet objects and the database. The DataAdapter Class used to fill a DataTable or DataSet Objects with the data from the database by using the Fill() method. The DataAdapter class applies changes thatare made in the dataset to the database by calling the Update() method.

It also provides four properties that represents the database command:

a) SelectCommand,

b) nsertCommand,

c) DeleteCommand, and

d) UpdateCommand.