Chapter 18 Getting Started with ADO .NET 443
Records correspond to rows in the table, and fields correspond to columns, as shown in the
following faculty database (Faculty2010) in Access 2007:A relational database can consist of multiple linked tables. In general, most of the databases
that you connect to from Visual Studio will probably be relational databases that contain
multiple tables of data organized around a particular theme.In ADO .NET, various objects are used to retrieve and modify information in a database.
First, a connection is made, which specifies connection information about the database
and creates something for other controls and components to bind to. Next, the Data
Sources Configuration Wizard creates a dataset, which is a representation of one or more
database tables you plan to work with in your program. (You don’t manipulate the actual
data, but rather a copy of it .) The Data Sources Configuration Wizard also adds an XML
schema file to your project and associates a table adapter and data navigator with the(^) dataset to handle retrieving data from the database, posting changes, and moving from one
record to the next in the dataset. You can then bind information in the dataset to controls
on a form by using the Data Sources window or DataBindings property settings.