What is the Catch block used for?
a. Processing error conditions from a Try block. Any exception in the Try block will transfer control to the Catch block for determination.
True or false: ADO.NET cannot tell you if you have any errors indicated in a DataSet .
False. If utilized, this capability can retain errors on each row in the dataset.
True or false: Always close a connection in the Finally block.
True. In general, it is good practice to close a connection. Doing so in a Finally block is good practice if the open connection was in the corresponding Try block.
You can set errors in a DataSet at what level?
a, b, and c. You have the flexibility to set errors at all three levels. What's more, if you set an error at the row level, you can test the table for errors at higher levels (for example, at the table level using the HasErrors method).
True or false: There is no way to pass DataRow error indications to other XML consumers or Web services.
False. You can utilize the DiffGram structure to encapsulate the data, schema, and data row error information.
What is the most commonly used DataAdapter event?
c. RowUpdated is the most widely used event because it reflects the outcome of the updates against the data source after they have been completed. This usage is especially common when looking for optimistic concurrency violations.