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 ...