Sams Teach Yourself ADO.NET in 24 Hours

Typical Errors to Handle

When using the ADO.NET capabilities, much of what you will encounter centers on getting to data sources, pulling data out of data sources and into datasets, manipulation of the data within your datasets, and pushing that data back out to the data sources. The errors that you will see the most can be categorized as:

• Connection errors—Failure to connect, stay connected, disconnect, or other connection-related failures

• Data retrieval errors—Failure to get data, fill errors, and so on

• Dataset manipulation errors—Update, delete, or insert issues in your cached dataset

• Data source manipulation errors—Failures of deletes, inserts, or updates such as optimistic concurrency violations or primary key constraint violations, and so ...