These objects connect one or more Command objects to a Dataset object. They provide logic that would get data from the data store and populates the tables in the Dataset, or pushes the changes in the Dataset back into the data store.
. An OleDbDataAdapter object is used with an OLE-DB provider
. A SqlDataAdapter object uses Tabular Data Services with MS SQL Server.