Use of data adapter

Explain the use of data adapter.

- The data adapter objects connect a command objects to a Dataset object.

- They provide the means for the exchange of data between the data store and the tables in the DataSet.

- An OleDbDataAdapter object is used with an OLE-DB provider.

- A SqlDataAdapter object uses Tabular Data Services with MS SQL Server.

- Data adapters are an integral part of ADO.NET managed providers, which are the set of objects used to communicate between a data source and a dataset.

- Adapters are used to exchange data between a data source and a dataset.

- In many applications, this means reading data from a database into a dataset, and then writing changed data from the dataset back to the database.

- However, a data adapter can move data between any source and a dataset. For example, there could be an adapter that moves data between a Microsoft Exchange server and a dataset.
What are basic methods of Dataadapter?
The most commonly used methods of the DataAdapter are.....
What is Dataset object? Explain the various objects in Dataset
The DataSet object is a disconnected storage, it is used for manipulation of relational data....
What are the steps involved to fill a dataset?
We fill it with data fetched from the data store. Once the work is done with the dataset, connection is reestablished....
Post your comment