Figure : Creating a relationship between two tables Note Remember: You're unselecting these columns, so you uncheck the columns for the Orders table | Figure Creating a relationship between two tables Note Remember You re unselecting these columns so you uncheck the columns for the Orders table. Figure shows the completed dialog box with the selected columns to display from each table. Figure Selecting the columns to display from each table 8. Click the Next button to proceed. 9. Select the display style for the rows also known as records in the parent table that are displayed in your form. You can display the rows in a grid or you can display each column using a separate control. You ll use a separate control for the columns so select the Single Record in individual controls radio button. The other check boxes in the dialog box allow you pick the controls you want to add to your form. These controls affect the rows in the master table and you can add the following controls to your form Note In this example the parent table is the Customers table and the child table is the Orders table. The rows for the child table are displayed in a DataGrid control. o Cancel All The Cancel All button allows you to undo any changes you ve made to the current row. o Add The Add button allows you to add a new row. o Delete The Delete button allows you to delete the current row. o Cancel The Cancel button allows you to cancel a change made to the current row. o Navigation Controls The Navigation controls consist of four buttons that allow you to move to first row the previous row the next row and the last row. An indicator is also displayed to show the current row. Figure shows the completed dialog box. Figure Choosing the display style 10. You ve now completed all the steps in the Data Form Wizard. Click the Finish button to create your form. VS .NET will now display the new form as shown in Figure . Figure The completed form The managed provider objects in your form use the OLE DB classes contained in the namespace-even though a SQL Server database is used. These objects work .
