The best and common coding technique for catching and handling the Errors and Exceptions in ASP.Net for specific ADO.Net Data Providers is using try… catch … finally block. In try …catch block, try section is used to cover the piece of code that can throw an error or exception and catch block is used to catch that error or exception using base Exception object or code specific Exception handler. E.g. SqlException class object is used to handle the SQL Server .Net Data Provider in ADO.Net data access coding.

Basic try..catch Block

When you are using more than 1 catch block like in above example code, always remember to set the order of catch block from more specific exception handling to less specific block. This enables you to handle and display the more specific error messages according to the execution order of try …catch block.

SqlException class provides the following properties for any error or exception handled by it:

• Message: String describing the error.
  
  
• Number: Uniquely identifying Number for any error type.
  
  
• Errors: Collection of errors with detailed information for specific exception.
  
  
• State: It contains the additional information about the state of the error to indicate the occurrence of specific error e.g. if any stored procedure is generating the same error for different lines then the state is used to identify the specific occurrence.