S
Stimp
I have the following Try, Catch, Finally block...
Dim objConn As SqlConnection = New SqlConnection(ConfigurationSettings.
AppSettings("conn"))
objConn.Open()
Try
Dim strSQL As String = "SELECT COUNT(id) FROM Table1 " & _
"WHERE idCreatedBy = @idCreatedBy"
Dim objCmd As SqlCommand = New SqlCommand(strSQL, objConn)
'Add input parameters
objCmd.Parameters.Add("@idCreatedBy", SqlDbType.Int).Value = 123
Return objCmd.ExecuteScalar
Catch ex As Exception
Return False
Finally
objConn.Close()
End Try
my question is: Does the 'Finally' always run even after exiting the
'Try' statement by using a 'Return' ?
Thanks!
Dim objConn As SqlConnection = New SqlConnection(ConfigurationSettings.
AppSettings("conn"))
objConn.Open()
Try
Dim strSQL As String = "SELECT COUNT(id) FROM Table1 " & _
"WHERE idCreatedBy = @idCreatedBy"
Dim objCmd As SqlCommand = New SqlCommand(strSQL, objConn)
'Add input parameters
objCmd.Parameters.Add("@idCreatedBy", SqlDbType.Int).Value = 123
Return objCmd.ExecuteScalar
Catch ex As Exception
Return False
Finally
objConn.Close()
End Try
my question is: Does the 'Finally' always run even after exiting the
'Try' statement by using a 'Return' ?
Thanks!