for RuBoard

These quiz questions are designed to test your knowledge of the material covered in this chapter. The answers to the quiz questions can be found in Appendix A, "Answers to Quizzes."



CommandBuilder will generate UPDATE and DELETE statements following which concurrency model?

  1. Pessimistic concurrency model

  2. Optimistic concurrency model

  3. Data update concurrency model


True or false: Automatically generated commands will be created for all SelectCommands coded in Visual Basic or C#.


What must be done following the change of a SELECT statement when using CommandBuilder to automatically generate code?

  1. Reassign SELECT variables

  2. Refresh metadata

  3. Close connection

  4. Open connection


True or false: The following SELECT statement is valid for using with CommandBuilder :

 SELECT a.*, b.* FROM Customers a, Orders b WHERE a.CustomerID = b.CustomerID 

The SelectCommand that will be used for the CommandBuilder must:

  1. Include a SELECT Distinct clause

  2. Contain all columns in the table

  3. Return at least one primary key or unique column

  4. Contain a WHERE clause with at least one filter


Take (download) the original non- CommandBuilder sample code (19NormalUpd.vb) and manually convert it to use automatically generated commands with CommandBuilder . You can use either the OleDBCommandBuilder or SqlCommandBuilder objects.

After you have completed this conversion (and it works!), add in an insert and delete that also uses the automatically generated commands.

for RuBoard

Sams Teach Yourself ADO. NET in 24 Hours
Sams Teach Yourself ADO.NET in 24 Hours
ISBN: 0672323834
EAN: 2147483647
Year: 2002
Pages: 237 © 2008-2017.
If you may any questions please contact us: