(vb+Sqlserver:) AdoConn.BeginTrans
'.......
sqlstring = _
"DELETE FROM [USER] WHERE USER.UserID='" & UserIDSelected & "'"
'.......
sqlstring = _
"INSERT INTO [USER] VALUES ('" & Trim(TxtUserID.Text) & "','" & Trim(TxtUserName.Text) & "'," & _
"'" & strDepID & "','" & strDepName & "'," & _
"'" & PassCode & "'," & longPropertyID & ",'" & strUserPropertyName & "')"
if 无异常
'进行事务处理
AdoConn.CommitTrans
Else
'如果有错误,则取消修改并结束事务
'------------------------------
AdoConn.RollbackTrans
End If
'.......
sqlstring = _
"DELETE FROM [USER] WHERE USER.UserID='" & UserIDSelected & "'"
'.......
sqlstring = _
"INSERT INTO [USER] VALUES ('" & Trim(TxtUserID.Text) & "','" & Trim(TxtUserName.Text) & "'," & _
"'" & strDepID & "','" & strDepName & "'," & _
"'" & PassCode & "'," & longPropertyID & ",'" & strUserPropertyName & "')"
if 无异常
'进行事务处理
AdoConn.CommitTrans
Else
'如果有错误,则取消修改并结束事务
'------------------------------
AdoConn.RollbackTrans
End If
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货