The Microsoft .NET Framework provides a rich set of approaches, mechanisms, and events to handle the myriad of runtime code error situations that are possible for any type of application you will be writing ”whether it is Web or Windows forms. One significant addition for .NET involves being able to add error messages to each row of data in a DataSet . This enables you to zoom in on issues on a row-by-row basis. In addition, these row errors persist with the DataSet even when being transferred using XML or XML Web services. This chapter deals with the errors that directly relate to ADO.NET and identifies the typical error scenarios you need to be aware of along with presenting several basic principles of how to handle ADO.NET- related errors. We will not cover them all, just the ones you need to survive with.
In this hour, you will learn about the following topics:
Formal error handling for ADO.NET
The most common errors that you must deal with
A sample application with many of the basics