Guys,

I'm fairly comfortable with the concept of Try/Catch/Finally but recently I'm trying to use the 'using' statement more often and this has confused me.

I have some code that looks like this....

Code:
        Using conSQL As New SqlConnection(ConnectionString)
            conSQL.Open()
            Using txSQL As SqlTransaction = conSQL.BeginTransaction
                Using cmdInsert1 As New SqlCommand("StoredProc1", conSQL, txSQL)
                    cmdInsert1.CommandType = CommandType.StoredProcedure
                    'add parameters here...
                    cmdInsert1.ExecuteNonQuery()
                End Using
                Using cmdInsert2 As New SqlCommand("StoredProc2", conSQL, txSQL)
                    cmdInsert2.CommandType = CommandType.StoredProcedure
                    'add parameters here...
                    cmdInsert2.ExecuteNonQuery()
                End Using
                txSQL.Commit()
            End Using
        End Using
Can anyone tell me how I should be using try/catch blocks in such code to handle exceptions?

Does the try/catch go inside the using statement or do I wrap the entire 'using block' in a try/catch?

Thanks in advance for your time, much appreciated.


Chris.