Sql Transaction Begin, Commit, Rollback Demo in asp.net
Posted by Viral Sarvaiya on September 18, 2009
Some programmer require to rollback and commit the transaction of the sqlserver according to the coding. That time this code will help you….
Imports System Imports System.Data Imports System.Data.SqlClient public class MainClass Shared Sub Main() Dim thisConnection As New SqlConnection("server=(local)\SQLEXPRESS;" & _ "integrated security=sspi;database=MyDatabase") ' SQL Delete Commands Dim sql As String = "DELETE FROM Employee " & _ "WHERE ID = 10" ' Create command Dim thisCommand As New SqlCommand(sql, thisConnection) ' Create Transaction Dim thisTransaction As SqlTransaction Try ' Open Connection thisConnection.Open() ' Begin transaction and attach it to command thisTransaction = thisConnection.BeginTransaction() thisCommand.Transaction = thisTransaction ' Run delete command thisCommand.ExecuteNonQuery() ' Commit transaction thisTransaction.Commit() ' Display success Console.WriteLine("Transaction Committed. Data Deleted") Catch ex As Exception ' Roll back transaction thisTransaction.Rollback() Console.WriteLine("Transaction rolled back : " & ex.Message) Finally ' Close Connection thisConnection.Close() End Try End Sub End Class
for more information click here