Matt Clingan’s Registered & Protected Blog Entry

I’ve always committedd/rolled back my transactions in my sql statements.  This morning mitch introduced me to the SqlTransaction object.  Thanks mitch!

Public Sub Test()
        Dim cn As New SqlConnection
        Dim cmd As SqlCommand
        Dim Tran As SqlTransaction
        Try
            Tran = cn.BeginTransaction
            For Each s As String In Now.ToString
                cmd = New SqlCommand(“insert”, cn)
                cmd.Transaction = Tran
                cmd.ExecuteNonQuery()
            Next
            Tran.Commit()
        Catch ex As Exception
            Tran.Rollback()
        Finally
            cn.Close()
        End Try
End Sub