Transaction

Can anyone tell me if this is the best way to do this.           Dim MyConn As New SqlConnection(ConfigurationManager.ConnectionStrings("WriteConnString").ConnectionString)
Dim MyCommand As SqlCommand
Dim MyTransaction As SqlTransaction = Nothing
' Try it using a transaction

Try
MyConn.Open()
MyTransaction = MyConn.BeginTransaction
MyCommand = New SqlCommand("DELETE FROM Authorities_Contacts WHERE AuthorityID = @AuthID", MyConn)
MyCommand.Parameters.Add("@AuthID", Data.SqlDbType.BigInt, 8)
MyCommand.Parameters("@AuthID").Value = RecordToDelete
MyCommand.Transaction = MyTransaction
MyCommand.ExecuteNonQuery()
MyCommand = New SqlCommand("DELETE FROM Authorities_Social_Services WHERE AuthorityID = @AuthID", MyConn)
MyCommand.Parameters.Add("@AuthID", Data.SqlDbType.BigInt, 8)
MyCommand.Parameters("@AuthID").Value = RecordToDelete
MyCommand.Transaction = MyTransaction
MyCommand.ExecuteNonQuery()
MyCommand = New SqlCommand("DELETE FROM Authorities WHERE AuthorityID = @AuthID", MyConn)
MyCommand.Parameters.Add("@AuthID", Data.SqlDbType.BigInt, 8)
MyCommand.Parameters("@AuthID").Value = RecordToDelete
MyCommand.Transaction = MyTransaction
MyCommand.ExecuteNonQuery()
MyTransaction.Commit()
Catch ex As Exception
Response.Write(ex.Message.ToString)
MyTransaction.Rollback()
Finally
MyConn.Close()
End Try