在更新运行时创建进度面板 [英] Creating a Progress Panel while update is running

问题描述

嗨



在我的应用程序中，我有一个运行存储过程的进程，因为有很多数据需要导入和更新（Apprx 1.3 mil记录） ）它需要大约5-10分钟才能运行。



我想知道我怎么能创建一个启动页面或div来显示处理更新到数据库请稍候。

解决方案

嗯，你可以做类似下面的事情：



有一个gif图像和一些文字比如div中的'Executing'，sp开始执行的那一刻，显示div。一旦你显示div，gif图像就会随文本一起出现。

在你的sp中有一个标志，一旦你的sp完成执行就会被设置为某个值。检索该标志值，检查它是否等于你设置的默认值，如果是，则隐藏div。



无论你做什么都应该。这个想法可能很模糊，但它是一种方法。

尝试它



问候

Anurag

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.

解决方案

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

这篇关于在更新运行时创建进度面板的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！