Click here to Skip to main content
15,907,281 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi

In my application i have a process that runs a stored proc , because there is a lot of data to be imported and updated (Apprx 1.3 mil records) it takes about 5-10min to run.

I would like to know how could i create a splash page or a div to show Processing updates to the database please wait.
Posted

1 solution

Well, you can do something like below:

Have a gif image and some text like 'Executing' in a div, the moment your sp starts its execution, show the div. As soon as you show the div, the gif image will come with the text.
have a flag in your sp which will be set to some value as soon as your sp completes its successful execution. Retrieve that flag value, check whether its equal to the default which you have set, if yes, hide the div.

It should whatever you wana do. The idea may be lil vague, but its an approach.
try it

regards
Anurag
 
Share this answer
 
Comments
isi19 30-Aug-13 4:44am    
Thanks Logically makes sense
Anurag Sinha V 30-Aug-13 4:52am    
Yep...just keep a track as to how will your UI code take into account the flag values at the start and end of the stored procedure..Am sure you'll find a method for quick retrieval...
Have fun!!!

regards
Anurag

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900