CommittableTransaction Constructor ()
Initializes a new instance of the CommittableTransaction class.
Assembly: System.Transactions (in System.Transactions.dll)
An attempt to create a transaction under Windows 98, Windows 98 Second Edition or Windows Millennium Edition.
The following sample creates a new instance of CommittableTransaction and commits it.
tx = New CommittableTransaction Dim myConnection As New SqlConnection("server=(local)\SQLExpress;Integrated Security=SSPI;database=northwind") Dim myCommand As New SqlCommand() 'Open the SQL connection myConnection.Open() 'Give the transaction to SQL to enlist with myConnection.EnlistTransaction(tx) myCommand.Connection = myConnection 'Restore database to near it's original condition so sample will work correctly. myCommand.CommandText = "DELETE FROM Region WHERE (RegionID = 100) OR (RegionID = 101)" myCommand.ExecuteNonQuery() 'Insert the first record. myCommand.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (100, 'MidWestern')" myCommand.ExecuteNonQuery() 'Insert the second record. myCommand.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (101, 'MidEastern')" myCommand.ExecuteNonQuery() 'Commit or rollback the transaction Dim c As ConsoleKeyInfo While (True) Console.Write("Commit or Rollback? [C|R] ") c = Console.ReadKey() Console.WriteLine() If (c.KeyChar = "C") Or (c.KeyChar = "c") Then tx.Commit() Exit While ElseIf ((c.KeyChar = "R") Or (c.KeyChar = "r")) Then tx.Rollback() Exit While End If End While myConnection.Close() tx = Nothing
Available since 2.0