急~在线等!关于事务问题
我在用vb.net和sqlserver做项目中,遇到一个对我来说不小的问题
我也是第一次用。net做东西,呵呵
关于事务上问题
.net自带了sqltransaction这个类用于处理连接sqlserver的事务,但是我在对事务加锁的时候,不知道如何加锁
Dim myTrans As SqlTransaction
myTrans = conn.BeginTransaction
objCommand = conn.CreateCommand
objCommand.Connection = conn
objCommand.Transaction = myTrans
//// 'myTrans.IsolationLevel = IsolationLevel.Serializable (这里)
objCommand.CommandText = "update accountamount where account = '" + eaccount + "' set amount = amount - " + Trim(txtamount.Text)
objCommand.ExecuteNonQuery()
objCommand.CommandText = "update accountamount where account = '" + Trim(txtaccount.Text) + "' set amount = amount + " + Trim(txtamount.Text)
objCommand.ExecuteNonQuery()
myTrans.Commit()
对事务加锁我用了这句'myTrans.IsolationLevel = IsolationLevel.Serializable 可是.net提示错误,IsolationLevel is
read only
我不知道如何处理,也就是如何对事务加锁
请大虾们指点迷津
小弟在此谢过