计算机科学与技术：VB.NET应用教程 教学课件 作者 978 7 302 09622 1 Advanced VB.NET Chapter 10.pptVIP

Copyright 2004 Pearson Education, Inc. Chapter 10 The Connected Layer Command and Data Reader Classes Objectives A Quick Review of Essential SQL with the Query Builder The SQL Select Command The Command Class The Data Reader More Properties and Methods The XML Reader Reading the Database Schema Parameters and the Command Object Managing Transactions Brief Look at Stored Procedures Lab 10: The Command, DataReader, and Parameter Classes Suggested Home Assignments Opening The Query Builder The Query Builder The Query Builder The Query Builder Objectives A Quick Review of Essential SQL with the Query Builder The SQL Select Command The Command Class The Data Reader More Properties and Methods The XML Reader Reading the Database Schema Parameters and the Command Object Managing Transactions Brief Look at Stored Procedures Lab 10: The Command, DataReader, and Parameter Classes Suggested Home Assignments The Select Command Selects rows and columns from a table. Columns can be limited by specifying only the wanted ones. Rows can be limited through a Where clause. The Select Command The results can be sorted with the Order By clause. By default order is in ascending order. To make the order descending add the keyword DESC. With several items in the Order By, the sort order will be by the first item and within it be the second item, and so on. Example Discussion / Project With the Query Builder, Show all the pets and each pet’s owner. The pets who belong to male friends. Show the age of the friends who have pets, To do this join the Friends and Pets table. Show the age of the male friends who have pets. Show the friends who have both pets and cars. Discussion / Project With the Query Builder Show the friends who are married to each other, To do this join Friends with another copy of Friends and make the join based on Spouse in one table being the same as First Name in the other and make the Last Name the same in both tables. Who are the friends with whom the Diary says y