VB.NET事務(wù)處理主要代碼實現(xiàn)方式解讀
作者:佚名
我們可以通過以下這段代碼示例來對VB.NET事務(wù)處理的相關(guān)方法進行詳細解讀,以便將來的實際使用。幫助大家提高對VB.NET的認識。
VB.NET編程語言主要是面向?qū)ο?,并且可以為開發(fā)人員提供一個穩(wěn)固安全的編程框架。在使用的過程中就會發(fā)現(xiàn)其特有的性質(zhì)可以為我們帶來輕松的代碼編寫。在這里就先從VB.NET事務(wù)處理來對此進行一個解讀。#t#
VB.NET事務(wù)處理代碼示例:
- [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事務(wù)處理相關(guān)代碼編寫方式就為大家介紹到這里。
責任編輯:曹凱
來源:
博客園