Web Control Error Handling

[MrTee]

I'm using Visual Studio .NET to create an ASP.NET app with database access. I've set up the database access using the Visual Studio .NET web controls that are provided (SQLConnection, SQLDataAdapter, etc.)

My problem is that I'm not sure how to catch connection errors. The code that handles the database connections is generated by Visual Studio.

Is there a way to catch and handle these errors?

 

[Derek Stone]

You'll need to place a try/catch block around the code that generates the exception.

Try
     connection.Open()
Catch sqlEx As SqlException
     Log.Write(sqlEx)
Finally
     If Not connection Is Nothing
          connection.Close()
          connection.Dispose()
     End If
End Try