Chapter 6. ADO .NET DataAdapters

DataAdapters are the interface components that sit between the DataSet and the database. They contain the commands necessary to read data and optionally update the database with changes made to the DataSet. There are also some helper classes that make our programming lives easier. They do this by creating the Update statements from the Select statement we provided, and by fetching parameter lists for stored procedures from the database. So far, we have only seen how to connect to a database. Now we will actually get data and do updates.