DataSet and DataAdapter Binding
One of the most powerful features of ADO.NET and managed data providers is that any managed provider that implements a DataAdapter is fully, and automatically, compatible with the DataSet. In this next section, you will see how to configure a DataAdapter in such a way that you can push changes made in the DataSet to the original data source in a seamless, integrated, and almost invisible fashion.
As you probably know by now, a DataSet is an in-memory representation of a table and column structure. Tables within a DataSet can be related to each other through relationships that establish parent/child relationships, and tables in a DataSet support the notion of primary and foreign keys. They are essentially ...