把循环放在事务里面,包括所有的SQL语句应该可以的。
给你个例子
Dim myConnection as SQLConnection = new SQLConnection("")
Dim myCommand as SQLCommand = new SqlCommand()
Dim myTrans as SqlTransaction
myConnection.Open()
myCommand.Connection = myConnection
myTrans = myConnection.BeginTransaction()
myCommand.Transaction = myTrans
try
myCommand.CommandText =“”
myCommand.ExecuteNonQuery()
myCommand.CommandText =“”
myCommand.ExecuteNonQuery()
myTrans.Commit()
catch e as Exception
myTrans.Rollback()
finally
myConnection.Close()
end try