Foxtable(狐表)用户栏目专家坐堂 → BeginTransaction怎么设置隔离等级?


  共有2362人关注过本帖平板打印复制链接

主题:BeginTransaction怎么设置隔离等级?

帅哥哟,离线,有人找我吗?
有点甜
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:版主 帖子:85326 积分:427815 威望:0 精华:5 注册:2012/10/18 22:13:00
  发帖心情 Post By:2018/8/9 16:04:00 [只看该作者]

如果自己写事务,参考

 

Dim str_oleConn As String = Connections("test").ConnectionString
Dim ole_conn As New System.Data.OleDb.OleDbConnection(str_oleConn)
ole_conn.Open()
Dim command As System.Data.OleDb.OleDbCommand = ole_conn.CreateCommand()
Dim transaction As System.Data.OleDb.OleDbTransaction
transaction = ole_conn.BeginTransaction(System.Data.IsolationLevel.ReadCommitted)
command.Connection = ole_conn
command.Transaction = transaction
Try
    command.CommandText = "update kkk set 第一列='123'"
    command.ExecuteNonQuery()
   
    msgbox("成功")
    transaction.Commit()
Catch ex As Exception
    MessageBox.Show(ex.Message)
    transaction.Rollback()
Finally
    ole_conn.Close()
End Try


 


 回到顶部