Using RollBack Transactions in VB.NET

Sign in to answer this question.

• S

  Sairam12y agoPosted Dec 9, 2013, 5:23 AM

  I have just provided you the sample code., to set the  "SqlClient.SqlTransaction" to perform commit and rollback options.
  
  Make changes according to your need
  
  dim err
  Dim gTrans As SqlClient.SqlTransaction
    Dim gConnection As New System.Data.SqlClient.SqlConnection
    Dim SqlSelectTrans As System.Data.SqlClient.SqlCommand
  
  'SEt the connection String 
  '**************************
  gConnection.ConnectionString = ConnectionString
  
  
              try
                  If gConnection.State = ConnectionState.Closed Then
                      gConnection.Open()
                  End If
              Catch sqlEx As SqlClient.SqlException
                      Exit Function
                  End If
              End Try
  
  
  
  
  
       try
           gTrans = gConnection.BeginTransaction
  
  
  

  'make a call to your StoredProcedure and insertion query

  'Set the below command 

  
  
  

           SqlSelectTrans.Transaction = gTrans

           SqlSelectTrans.Connection = gConnection

           SqlSelectTrans.ExecuteNonquery()

  
  

  catch ex as exception

          err=ex.message

  End try

  
  
  'Final Commit/Rollback will take place here 
  
        If Err <> "" Then
              gTrans.Rollback()
              gConnection.Close()
          Else
              gTrans.Commit()
          End If
  
• 

  Sanjeeb Lenka12y agoPosted Dec 3, 2013, 11:43 PM

  refer to this link it may help you:
  
  http://www.vb-helper.com/howto_net_db_transaction.html