In contrast, in chapter 16, you’ll learn how to create an untyped dataset.
NETとSQL Serverに仕事が集中している。現在はCMI Solutionsのアプリケーション設計者および上級開発者であり、Visual StudioとSQL Server 2005を使用している。.
Last week, we began our discussion of using data sources with databases in Visual Studio 2005. This article, the second of two parts, is excerpted from chapter 14 of the book The schema file created by the Data Source Configuration Wizard After you complete the Data Source Configuration Wizard, the new data source is displayed in the Data Sources window you saw in figure 14-1.
In addition to this data source, Visual Studio generates a file that contains the schema for the Data Set class.
This file defines the structure of the dataset, including the tables it contains, the columns that are included in each table, the data types of each column, and the constraints that are defined for each table.
It is listed in the Solution Explorer window and is given the same name you specified for the dataset in the last step of the Data Source Configuration Wizard with a file extension of xsd.
In figure 14-5, for example, you can see the schema file named MMABooks Data As you’ll learn later in this chapter, you can view a graphic representation of this schema by double-clicking on this file.Beneath the schema file, the Solution Explorer displays the file that contains the generated code for the Data Set class.In this figure, this code is stored in the MMABooks Data Set. When you create bound controls from the data source as shown in this chapter, the code in this class is used to define the Data Set object that the controls are bound to.Although you may want to view this code to see how it works, you shouldn’t change it. By the way, you should know that a dataset that’s created from a dataset class like the one shown here is called a typed dataset.The code in the dataset class makes it possible for you to refer to the tables, rows, and columns in the typed dataset using the simplified syntax you’ll see in this chapter and the next chapter.