Developing Matt

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