[eTech1]

Does a finally statement always execute in a try catch or does it only execute if an exception is caught?
I just want to know which is the correct way to execute a nonquery to catch a duplicate entry Access DB error.

                Try
                    myCommand.ExecuteNonQuery()
                Catch ex As Exception
                    rowsAffected = 0
                End Try
                myConnection.Close()

Or

                Try
                    myCommand.ExecuteNonQuery()
                Catch ex As Exception
                    rowsAffected = 0
                Finally
                    myConnection.Close()
                End Try

This post has been edited by eTech1: 10 September 2010 - 08:56 AM

[modi123_1]

It always executes - regardless of an exception occurring. Code 2 is right.

Quote

finally is used to guarantee a statement block of code executes regardless of how the preceding try block is exited.

http://msdn.microsof...28VS.71%29.aspx

This post has been edited by modi123_1: 10 September 2010 - 09:43 AM