Using the Data Form Wizard to Create a Windows Form In this section, you'll use the VS .NET Data Form Wizard to create a Windows application that accesses both the Customers and Orders tables. | Using the Data Form Wizard to Create a Windows Form In this section you ll use the VS .NET Data Form Wizard to create a Windows application that accesses both the Customers and Orders tables. The Orders table contains rows that represent orders placed by the customers. The rows in the Orders table are related to the rows in the Customers table through a foreign key The Orders table contains a column named CustomerID that is a foreign key to the CustomerID column of the Customers table CustomerID is the primary key for the Customers table . The use of the foreign key defines a parent-child relationship between the Customers and Orders tables. The form you ll create will display a row from the Customers table along with any related rows from the Orders table. To give you a clear idea of the final goal Figure shows the completed form up and running. Notice that the top part of the form shows the details for the row from the Customers table where the CustomerID is ALFKI the bottom part of the form contains a DataGrid control that displays the rows from the Orders table for that customer. When you move to the next row in the Customers table the rows from the Orders table for that customer are automatically displayed in the DataGrid. Figure The running form Perform these steps to begin build the form 1. Select File New Project. 2. In the New Project dialog box select Empty Project and enter DataFormWindowsApplication in the Name field. Because you ll be adding a new form to your new application shortly there s no need to have VS .NET generate the usual blank form for you that s why you re creating an empty project. 3. Click OK to continue. VS .NET will create a new empty project for you. Next you ll use the Data Form Wizard to create a form that accesses the Customers and Orders tables in the Northwind database 1. Select Project Add New Item. 2. Select Data Form Wizard from the Templates section on the right enter the Name of the form as and click
