ExecuteScalar not working in RowDeleted

This public forum is for user-to-user discussions of ASP.NET Maker. Note that this is not support forum.
Post Reply
emlim896
User
Posts: 13

ExecuteScalar not working in RowDeleted

Post by emlim896 »

Hello,

I used ASP.NET Maker 2022. When using Executecalar() in RowDeleted got error "Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

But it worked in RowDeleting(), RowInserting(), RowInserted(), RowUpdating() and RowUpdated().

My code:

object _sum = ExecuteScalar("select sum(Quantity) from Orders_Items");

Appreciate for any help.

Thanks


MichaelG
User
Posts: 1095

Post by MichaelG »

Try disabling UseTransaction for delete. In delete page Page_Load server event, add:

UseTransaction = false;


emlim896
User
Posts: 13

Post by emlim896 »

Great, that works. Thank you!


Post Reply