VB.NET事務處理主要代碼實現方式解讀
作者:佚名
我們可以通過以下這段代碼示例來對VB.NET事務處理的相關方法進行詳細解讀,以便將來的實際使用。幫助大家提高對VB.NET的認識。
VB.NET編程語言主要是面向對象,并且可以為開發人員提供一個穩固安全的編程框架。在使用的過程中就會發現其特有的性質可以為我們帶來輕松的代碼編寫。在這里就先從VB.NET事務處理來對此進行一個解讀。#t#
VB.NET事務處理代碼示例:
- [Visual Basic]
- Public Sub RunSqlCeTransaction
(myConnString As String) - Dim myConnection As New SqlCe
Connection(myConnString) - myConnection.Open()
- Dim myCommand As New SqlCeCommand()
- Dim myTrans As SqlCeTransaction
- ' Start a local transaction
- myTrans = myConnection.BeginTransaction()
- ' Must assign both transaction object
and connection - ' to Command object for a pending
local transaction - myCommand.Connection = myConnection
- myCommand.Transaction = myTrans
- Try
- myCommand.CommandText = "Insert into
Region (RegionID, RegionDescription)
VALUES (100, 'Description')" - myCommand.ExecuteNonQuery()
- myCommand.CommandText = "Insert into
Region (RegionID, RegionDescription)
VALUES (101, 'Description')" - myCommand.ExecuteNonQuery()
- myTrans.Commit()
- Catch
- Try
- myTrans.Rollback()
- Catch e As SqlCeException
- ' Handle possible exception here
- End Try
- Finally
- myConnection.Close()
- End Try
- End Sub
VB.NET事務處理相關代碼編寫方式就為大家介紹到這里。
責任編輯:曹凱
來源:
博客園