SQLhelper使用事务_sqlhelper 事务-优快云博客

本文链接：https://blog.youkuaiyun.com/liuyunfan/article/details/7571411

本文介绍了一个使用SQL Server进行事务处理的VB.NET示例代码。该示例演示了如何通过开始事务、执行SQL命令并在成功时提交或失败时回滚来确保数据操作的一致性和准确性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1、声明连接myConnectString

2、开启事务BeginTransaction

3、执行时使用st

4、成功提交，失败回滚

Public function testshiwu()

Dim strSQL As String
Dim myConnectString As String = o.GetConn
Dim myConnection As New SqlConnection(myConnectString)
myConnection.Open()
Dim st As SqlTransaction = myConnection.BeginTransaction()
Try
'插入用户
strSQL = "Insert into EC_User(cUserID,cUserName,cPassword,cDepCode,badministrator,buse,bDel,cdyzm,cip,cdemo) "
strSQL += "values('test','test','test','01',0,0,0,'t','','')"
SqlHelper.ExecuteNonQuery(st, CommandType.Text, strSQL)
'更新用户
strSQL = "update ec_user set cusername='aaa' where cuserid='test' "
SqlHelper.ExecuteNonQuery(st, CommandType.Text, strSQL)
'再次插入用户，违反主键约束，事务回滚
strSQL = "Insert into EC_User(cUserID,cUserName,cPassword,cDepCode,badministrator,buse,bDel,cdyzm,cip,cdemo) "
strSQL += "values('test','test','test','01',0,0,0,'t','','')"
SqlHelper.ExecuteNonQuery(st, CommandType.Text, strSQL)

st.Commit()

return "success"

Catch ex As Exception
st.Rollback()
MsgBox(ex.Message, MsgBoxStyle.Critical, "发生错误")
Return ""
Finally
myConnection.Close()
End Try

End Sub