Doyle: C#, 5th edition Page 1-1
C# Programming: From Problem Analysis to Program Design, 5th edition
Chapter 14
1. d. dataset
2. e. Access
7. b. SELECT * FROM customer
8. a. @ followed by an identifier
14. a DataAdapter
15. d. Close( )
Doyle: C#, 5th edition Page 1-2
16. c. TableAdapter
17. c. TableAdapter Fill( ) method
21. The command class is used to hold the SQL query used to retrieve specific records. The
data reader class allows read-only forward retrieval of data from the database. You can
sequentially loop through the query results with the data reader object. Dataset used in
dataset object. You fill the dataset using the data adapter by specifying the name of the
table to use as the data source. If you associate the data source with a data grid object, such
22. a. SELECT partNumber, partDescription FROM Parts
Doyle: C#, 5th edition Page 1-3
b. SELECT partDescription FROM Parts
23. The DataGridView class is instantiated and all of the columns from the table are placed in
this control structure on the form. You can delete or modify the grid like structure using the
control’s smart tag. In addition, four other objects are placed in the component tray below
Doyle: C#, 5th edition Page 1-4
24. In addition to using the DataGridView, which is the default control, you can select Details
prior to dragging a column to the form. This is available when you right-mouse click on the
25. The TableAdapter provides more functionality. It has a built in connection object and