Simple Transaction Commit and RollBack: SqlTransaction has completed; it is no longer usable.

Imports System
Imports System.Data
Imports System.Data.SqlClient

public class MainClass
   Shared Sub Main()
        Dim myconnection As SqlConnection
        Dim mycommand As SqlCommand
        Dim mytransaction As SqlTransaction
        Dim ConnectionString As String


        myconnection = New SqlConnection("server=(local)\SQLEXPRESS;" & _
          "integrated security=sspi;database=MyDatabase")

        myconnection.Open()

        'start a transaction
        mytransaction = myconnection.BeginTransaction()

        'configure command object to use transaction
        mycommand = New SqlCommand
        mycommand.Connection = myconnection
        mycommand.Transaction = mytransaction

        Try
            mycommand.CommandText = "insert into Employee(ID," & _
                      "FirstName,LastName) values(119, " & _
                      "'F','L')"
            mycommand.ExecuteNonQuery()

            mytransaction.Rollback()
            Console.WriteLine("Rollback()")
            mycommand.CommandText = "insert into Employee(ID," & _
                      "FirstName,LastName) values(119, " & _
                      "'F','L')"
            mytransaction.Commit()
        Catch e As Exception
            Console.WriteLine(e.Message)
        Finally
            myconnection.Close()
        End Try
   End Sub
End Class

Related examples in the same category

1.	Transaction save point and roll back
2.	Transaction Rollback Demo
3.	Transaction Commit Demo
4.	DataSet transaction
5.	Isolation Level ReadUncommitted

Simple Transaction Commit and RollBack: SqlTransaction has completed; it is no longer usable. : Transaction « Database ADO.net « VB.Net

Related examples in the same category