May be I am missing something but I find this behavior odd.
I am running an application which runs a stored procedure upon clicking a
button.
The stored procedure is called in the Click event of the button
However, after some time (when the stored procedure is still executing) the
ASP.NET page code seems to load all over again (as if the page was
refreshed), including the Click event. This causes the stored procedure to
execute another time as well.
I am quite confused with this since I have seen this for the first time.
If I have just a smaller process running in the Click event instead of the
time consuming stored procedure, everything works as normal and the
application returns.
Thank you in advance for your help.