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
enjoy coding….
