hi....

i have trigger that chk the if there is enough quantity for some items in the stock when the user place an order,so i raise error when there is not enough quantity and rollback the operation.

the trigger work well ..but when i receive the first error (my own) and trying to reupdate i receive the error (DBConcurrencyException) even when i rollback the transaction in the trigger when the error happend. it seems the ado or the dataset did not know the transaction has been canceld.

so whats is going on

thanks .