Programming Microsoft® ADO.NET 2.0 Core Reference, 2nd Edition

Introducing TableAdapters

Earlier in the chapter, when you first constructed your DataSet, you saw that each DataTable you created by dragging and dropping columns from Server Explorer also created something called a TableAdapter. Now it’s time to take a closer look at TableAdapters.

A TableAdapter provides some of the basic logic associated with DataAdapter classes such as the SqlDataAdapter. You can use a TableAdapter to fill a DataTable in a strongly typed DataSet, or to submit the pending changes stored in a DataTable. We’ll take a closer look at using SqlDataAdapters to submit pending changes in Chapter 10 and Chapter 11. TableAdapters offer similar overloads for the Update method, so much of the information covered there applies to TableAdapters ...