Code Simplified – Viral Sarvaiya

Code Simplified – Viral Sarvaiya, Web Developer Friends, dot net Developer, Sql Server Developer

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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: