450 Part IV Database and Web Programming
Note Visual Studio allows you to use just part of a database or to combine different
databases—a useful feature when you’re working to build datacentric applications.The items you select in this dialog box are referred to within the project as database
objects. Database objects can include tables of fields and records, database views, stored
procedures, functions, and other items unique to your database. The collective term for all
the database objects that you select is a dataset. In this project, the dataset is assigned the
default name Faculty2010DataSet, which you can adjust in the DataSet Name box.Tip Note that the dataset you create now only represents the data in your database—if
you add, delete, or modify database records in the dataset, you don’t actually modify the
underlying database tables until you issue a command that writes your changes back to
the original database. Database programmers call this kind of arrangement a disconnected
data source, meaning that there is a layer of abstraction between the actual database and
your dataset.- Click the arrow next to the Tables node to expand the list of the tables included in the
Faculty2010 .accdb database.
In this case, there is only one table listed, named Faculty, which we’ll use in our sample
program. - Click the arrow next to the Faculty node, and then select the check boxes for the Last
Name and Business Phone fields.
You’ll add these two fields to the Faculty2010DataSet dataset. The wizard page looks
like the following screen shot: