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.
|