Explain DataAdapter class

Question

Explain DataAdapter class in the ADO.NET?

Answer 1

DataAdapter class regain data from a database, stores data in the dataset, and returns the alterations made in a dataset to a database. DataAdapter class acts as the intermediary for every communication among database and a DataSet object. DataAdapter Class is used to fill the DataTable or the DataSet Object by data from the database using a Fill() method. DataAdapter class affects the alteration made in the dataset to a database by calling a Update() method.

DataAdapter class has four properties which represent a database command and these are as follows:

• SelectCommand,
• UpdateCommand
• InsertCommand,and DeleteCommand.