Visual Basic

Try
    ' setup our database connection.
    Dim conn As SqlConnection = GetConnection()
    Dim comm As New SqlCommand("blaa blaa blaa")
    Dim param As New SqlParameter(blaa blaa blaa)
    .
    .
    (more code to setup and execute our data access)
Catch ex As Exception
    ' Code to log the exception, throw a custom exception, or whatever to handle a failed request.
Finally
    ' Check to see if the connection is anything but closed!  Don't check for Open!
    If conn.State <> ConnectionState.Closed Then
        conn.Close()
    End If
    comm = Nothing
    conn.Dispose()
End Try

Dim myDialog As New DialogForm2
myDialog.ShowDialog(Me)