关于事务的一个问题

[webant]

myconnection.Open()
Dim mytrans As SqlTransaction = myconnection.BeginTransaction
myCommand.Transaction = mytrans
Try
...'数据库执行语句
mytrans.Commit()
Catch ex As Exception
mytrans.Rollback()
Throw ex
Finally
myconnection.Close()
End Try

以上一段代码，在执行提交操作是出错，出错信息如下：
This SqlTransaction has completed; it is no longer usable.
出错语句为：mytrans.rollback()

不知该如何解决？

[webant]

有没有人知道呀？

[zht825]

Public Sub RunSqlTransaction(myConnString As String)
Dim myConnection As New SqlConnection(myConnString)
myConnection.Open()

Dim myCommand As SqlCommand = myConnection.CreateCommand
Dim myTrans As SqlTransaction

' Start a local transaction
myTrans = myConnection.BeginTransaction("SampleTransaction")
' Must assign both transaction object and connection
' to Command object for a pending local transaction
myCommand.Connection = myConnection
myCommand.Transaction = myTrans

Try
myCommand.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (100, 'Description')"
myCommand.ExecuteNonQuery()
myCommand.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (101, 'Description')"
myCommand.ExecuteNonQuery()
myTrans.Commit()
Console.WriteLine("Both records are written to database.")
Catch e As Exception
Try
myTrans.Rollback("SampleTransaction")
Catch ex As SqlException
If Not myTrans.Connection Is Nothing Then
Console.WriteLine("An exception of type " & ex.GetType().ToString() & _
" was encountered while attempting to roll back the transaction.")
End If
End Try

Console.WriteLine("An exception of type " & e.GetType().ToString() & _
"was encountered while inserting the data.")
Console.WriteLine("Neither record was written to database.")
Finally
myConnection.Close()
End Try
End Sub 'RunSqlTransaction
好好看看事务的写法！希望对你有帮助！