What is the use of data adapter?
The Data adapter are the objects that connect one or more Command objects to a Dataset object. They give logic that would get data from the data store & populates the tables in the Data Set, or pushes the changes in the DataSet back into the data store.
1)An OleDbDataAdapter object is used with an OLE-DB provider
2)The SqlDataAdapter object uses the Tabular Data Services with the MS SQL Server.