Simple Transaction Commit and RollBack: SqlTransaction has completed; it is no longer usable. : Transaction « Database ADO.net « VB.Net

Home
VB.Net
1.2D
2.Application
3.Class
4.Data Structure
5.Data Types
6.Database ADO.net
7.Development
8.Event
9.File Directory
10.Generics
11.GUI
12.Language Basics
13.LINQ
14.Network Remote
15.Security
16.Thread
17.Windows Presentation Foundation
18.Windows System
19.XML
20.XML LINQ
VB.Net Tutorial
VB.Net by API
VB.Net » Database ADO.net » TransactionScreenshots 
Simple Transaction Commit and RollBack: SqlTransaction has completed; it is no longer usable.
Simple Transaction Commit and RollBack: SqlTransaction has completed; it is no longer usable.

Imports System
Imports System.Data
Imports System.Data.SqlClient

public class MainClass
   Shared Sub Main()
        Dim myconnection As SqlConnection
        Dim mycommand As SqlCommand
        Dim mytransaction As SqlTransaction
        Dim ConnectionString As String


        myconnection = New SqlConnection("server=(local)\SQLEXPRESS;" & _
          "integrated security=sspi;database=MyDatabase")

        myconnection.Open()

        'start a transaction
        mytransaction = myconnection.BeginTransaction()

        'configure command object to use transaction
        mycommand = New SqlCommand
        mycommand.Connection = myconnection
        mycommand.Transaction = mytransaction

        Try
            mycommand.CommandText = "insert into Employee(ID," & _
                      "FirstName,LastName) values(119, " & _
                      "'F','L')"
            mycommand.ExecuteNonQuery()

            mytransaction.Rollback()
            Console.WriteLine("Rollback()")
            mycommand.CommandText = "insert into Employee(ID," & _
                      "FirstName,LastName) values(119, " & _
                      "'F','L')"
            mytransaction.Commit()
        Catch As Exception
            Console.WriteLine(e.Message)
        Finally
            myconnection.Close()
        End Try
   End Sub
End Class


           
       
Related examples in the same category
1.Transaction save point and roll back
2.Transaction Rollback Demo
3.Transaction Commit Demo
4.DataSet transactionDataSet transaction
5.Isolation Level ReadUncommittedIsolation Level ReadUncommitted
www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.