Handling BLL- and DAL-Level Exceptions in an ASP.NET Page:
Step 2-Gracefully Handling DAL-Level Exceptions

This step of the VIDEO TUTORIAL will demonstrate on how to handle the exceptions that are resulted in data access layer during the update process. For example, if the product name is NOT supplied, a NoNullAllowedException results. If the database is down, then a SqlException results. If the exception is not handled properly it will result in a generic default error page. In order to handle these exceptions gracefully, an exception label is added to the ErrorHandling.aspx page. In order to display the exception gracefully during the GridView1_RowUpdated event handler, the use of Exception, ExceptionHandled and KeepInEditMode properties of GridViewUpdatedEventArgs parameter of the GridView1_RowUpdated handler are utilized. Finally, the exception handling at runtime is demonstrated. For detailed information and source code for this step, please refer to the original article.