数据保存问题？？？
Public Sub myDBcomm_Tran(ByVal Str1 As String, ByVal Str2 As String)
mycom = mycon.CreateCommand
MyTrans = mycon.BeginTransaction(IsolationLevel.ReadCommitted)
mycom.Connection = mycon
mycom.Transaction = MyTrans
Try
mycom.CommandText = Str1
mycom.CommandText = Str2
mycom.ExecuteNonQuery()
MyTrans.Commit()
Catch ex As Exception
MyTrans.Rollback()
MessageBox.Show(ex.Message, StrName, MessageBoxButtons.OK, MessageBoxIcon.Error)
Finally
mycon.Close()
End Try
End Sub
我是想通过事务来提交数据。。。
我这样传的是两条语句，，，为什么提交的时候只保存后面一记录？？
要是我想同时提交多条不同sql语句是，该怎来写哦？？？？
[解决办法]
mycom.CommandText = Str1
mycom.CommandText = Str2
导致mycom的sql命令只有最后Str2了，所以就只保存了后一条记录
改成
mycom.CommandText = Str1
mycom.ExecuteNonQuery()
mycom.CommandText = Str2
mycom.ExecuteNonQuery()
[解决办法]
要是我保存的insert into 和update 语句不确定的话，该怎么来写好点哦？？
insert into语句和Update语句不是由Public Sub myDBcomm_Tran(ByVal Str1 As String, ByVal Str2 As String)
的两个参数带进去的么？
mycom.CommandText = InsrtStr1
mycom.ExecuteNonQuery()
mycom.CommandText = updateStr2
mycom.ExecuteNonQuery()
使用起来也是一样的
[解决办法]
mycom = mycon.CreateCommand
MyTrans = mycon.BeginTransaction(IsolationLevel.ReadCommitted)
mycom.Connection = mycon
mycom.Transaction = MyTrans
Try
mycom.CommandText = "插入语句"
mycom.ExecuteNonQuery()
mycom.CommandText = "更新语句"
mycom.ExecuteNonQuery()
MyTrans.Commit()
Catch ex As Exception
MyTrans.Rollback()
MessageBox.Show(ex.Message, StrName, MessageBoxButtons.OK, MessageBoxIcon.Error)
Finally
mycon.Close()
End Try
[解决办法]
Try
mycom.CommandText = Str1
mycom.ExecuteNonQuery()
mycom.CommandText = Str2
mycom.ExecuteNonQuery()
MyTrans.Commit()
