You need to understand the
ado.net architecture[
^] first as all the above answers are correct.
DataAdapter provides the bridge between the
DataSet object(
DataTable etc.) and the data source.
The
DataAdapter uses Command objects to execute SQL commands at the data source to both load the
DataSet with data, and reconcile changes made to the data in the
DataSet back to the data source.
hope it helps :)