SQL Transaction Exception

[Zeyad Jalil]

Hi, When I update a table using sql transaction i got the following error: "This SqlTransaction has completed, it is no longer usable". Please help me to know what is the reason and how to solve this issue.

[Simon_Whale]

You need to show the code that this is happening on. I would guess you are trying to do additional work on the database after you have committed the transaction.

Every day, thousands of innocent plants are killed by vegetarians. Help end the violence EAT BACON

[Kornfeld Eliyahu Peter]

Look for SqlTransaction.Commit, you will find probably more than one and while debugging you will hit more than one... However for more detailed answer you must show your code to us...

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)

[BHARAT703]

My Friend, no. of animals or sea food used by non-vegetarians are in terms of billions/day... Just tell me, those animals are not innocent?

[Dave Kreskowiak]

Uhhhh...yeah. Whatever you're smoking for recreational purposes, STOP.

A guide to posting questions on CodeProject

Click this: Asking questions is a skill. Seriously, do it.
Dave Kreskowiak

[Dilan Shaminda]

check this answer here. It might help you :) http://stackoverflow.com/questions/6358806/this-sqltransaction-has-completed-it-is-no-longer-usable-configuration-er[^] This article is also explaining the same problem Zombie check on Transaction - Error : This SqlTransaction has completed; it is no longer usable.