Professional in C# and Visual Basic Part 48. Building on the revolutionary release, adds several key new developer features including AJAX, LINQ, and a new CSS designer in Visual Web Developer 2008. The dramatic reduction in code that developers realized from the more than 50 new server controls in now allows developers the time to make their applications more interactive with AJAX, to work with data in their preferred language with LINQ, and to build visually attractive and consistent standards-based sites with CSS. . | Chapter 8 Data Managementwith After you close the Add Table dialog box you see a visual representation of the table that you selected in the Query Builder dialog box see Figure 8-19 . You can then select some or all the fields to be returned from the query. For this example you want everything returned from both the Customers and the Orders table so select the first check box with the asterisk . Notice that the query listed in this dialog box now says select from Customers. After the word Customers add text to the query so that it looks like the following SELECT Customers. FROM Customers WHERE CustomerlD LIKE Customer With this query you specify that you want to return the customer information when the CustomerlD fits the parameter that you pass into the query from your code using Customer . After your query is in place simply click OK and then click the Next button to have not only the select query but also the insert update and delete queries generated for you. Figure 8-20 shows you the final page after all the queries have been generated. Figure 8-20 426 Chapter 8 Data Managementwith After you reach this point you can either click the Previous button to return to one of the prior steps in order to change a setting or the query itself or you can click the Finish button to apply everything to your TableAdapter. After you are finished using the wizard notice there is a visual representation of the CustomersTableAdapter that you just created see Figure 8-21 . Along with that is a DataTable object for the Customers table. The TableAdapter and the DataTable objects that are shown on the design surface are also labeled with their IDs. Therefore in your code you can address this TableAdapter that you just built by referring to it as . The second TableAdapter that queries the Orders table is then shown and referred to as . Figure 8-21 After you have the two .
