Web Resources
Answers to Self Review Exercises
20.1 |
a) SQL. b) rows, columns. c) primary key. d) DataSet. e) DataGridView. f) WHERE. g) ORDER BY. h) joining. i) foreign key. j) System.Data.SqlClient. k) System.Data. l) SqlCommand. m) BindingSource. |
20.2 |
a) False. INSERT and DELETE statements also change the database. Do not confuse the SQL UPDATE statement with the Update method of a TableAdapter. b) False. Multiple rows can have the same value for a foreign key. Providing the same value for the primary key in multiple rows breaks the Rule of Entity Integritydoing so prevents each row from being identified uniquely. c) True. d) True. e) True. f) False. A DELETE statement deletes all rows satisfying the selection criteria in its WHERE clause. g) False. A BindingNavigator allows users to browse and manipulate data displayed by another GUI control. A TableAdapter can Fill a DataSet. h) True. |
ASP NET 2 0, Web Forms and Web Controls
|