Chapter 18 Getting Started with ADO .NET 451
- Click the Finish button to complete and close the Data Source Configuration Wizard.
Visual Studio finishes the tasks of adding a database connection to your project
and configuring the dataset with the selected database objects. (Depending on how
the Visual Studio IDE has been used and configured, you might see a Data Sources tab
or window now .)- Click the Save All button on the Standard toolbar to save your changes. Specify the
C:\Vb10sbs\Chap18 folder as the location. - If Solution Explorer is not currently visible, open it now to display the major files and
components contained in the ADO Faculty Form project.
Your screen looks like this:
In addition to the standard Solution Explorer entries for a project, you see a new file
named Faculty2010DataSet .xsd. This file is an XML schema that describes the tables,
fields, data types, and other elements in the dataset that you have just created.
The presence of the schema file means that you have added a typed dataset to your
project. (Typed datasets have a schema file associated with them, but untyped
datasets don’t .) Typed datasets are advantageous because they enable the Microsoft
IntelliSense feature of the Visual Studio Code Editor, and they give you specific
information about the fields and tables you’re using.- Click the Faculty2010DataSet .xsd schema file in Solution Explorer, and then click the
View Designer button.
You see a visual representation of the tables, fields, and data adapter commands
related to your new dataset in a visual tool called the Dataset Designer. The Dataset
Designer contains tools for creating components that communicate between your
database and your application—what database programmers call data access layer
components. You can create and modify table adapters, table adapter queries, data
tables, data columns, and data relationships with the Dataset Designer. You can also
use the Dataset Designer to review and set important properties related to objects