The DataAdapter class retrieves DATA from the DATABASE, stores data in a DATASET, and reflects the changes made in the dataset to the database. The DataAdapter class acts as an intermediary for all the communication between the database and the DataSet object. The DataAdapter Class is used to fill a DataTable or DataSet Object with data from the database using the Fill() METHOD. The DataAdapter class applies the changes made in dataset to the database by calling the UPDATE() method. 
The DataAdapter class provides four properties that represent the database command: 
SelectCommand, InsertCommand, DeleteCommand, and UpdateCommand.

The DataAdapter class retrieves data from the database, stores data in a dataset, and reflects the changes made in the dataset to the database. The DataAdapter class acts as an intermediary for all the communication between the database and the DataSet object. The DataAdapter Class is used to fill a DataTable or DataSet Object with data from the database using the Fill() method. The DataAdapter class applies the changes made in dataset to the database by calling the Update() method. 
The DataAdapter class provides four properties that represent the database command: 
SelectCommand, InsertCommand, DeleteCommand, and UpdateCommand.