VB.NET中怎么实现事务处理
今天就跟大家聊聊有关VB.NET中怎么实现事务处理,可能很多人都不太了解,为了让大家更加了解,小编给大家总结了以下内容,希望大家根据这篇文章可以有所收获。
创新互联建站主营武鸣网站建设的网络公司,主营网站建设方案,app软件开发,武鸣h5小程序开发搭建,武鸣网站营销推广欢迎武鸣等地区企业咨询
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 transactionmyCommand.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中怎么实现事务处理有进一步的了解吗?如果还想了解更多知识或者相关内容,请关注创新互联行业资讯频道,感谢大家的支持。
分享文章:VB.NET中怎么实现事务处理
浏览地址:http://azwzsj.com/article/podpcd.html