Exercises

1. Modify the program given in the first sample to use the Employees table in the Northwind database. Retrieve the EmployeeID and LastName columns.

2. Modify the first program showing the Update() method to change the company name back to Bottom-Dollar Markets.

3. Write a program that asks the user for a Customer ID.

4. Write a program to create some orders for the customer Zachary Zithers; use the sample programs to view the orders.

5. Write a program to display a different part of the relationship hierarchies in the Northwind database than the one used in this chapter; for example, Products, Suppliers, and Categories.

6. Write out the data generated in the previous exercise as an XML document.

7. Change the program used to print all customer order details and products to use a WHERE clause in the SELECT statement for Customers, limiting the customers processed.

8. Modify the program shown to print out UPDATE, INSERT, and DELETE statements to use "SELECT * FROM Customers" as the SQL SELECT command. Note the complexity of the generated statements.