>If this worked properly to begin with (running the BeginExecuteNonQuery() rather than ExecuteNonQuery()), it could be that the page is already set up to run asynchronous stuff ... if so, you probably don't want to mess with it. Especially if the transaction problems you are getting are only because you've been debugging and not finishing your transactions while doing that. Restart your SQL Server or IIS (or kill the aspnet_wp.exe process from TaskManager) ... one of these things might get rid of your hanging transaction.
>
>~~Bonnie
>
Hi Bonnie,
I'm thinking that having trnsaction.commit() right after BeginExecute may be causing the problem. Anyway, I left everything not working, but I called later and the manger told me that he fixed everything and moved my code to production and the original problem seems to be fixed.
If it's not broken, fix it until it is.
My Blog