将数据从Excel工作表传输到数据库时的进度条 [英] Progress Bar While Transferring Data From Excel sheets To DataBase

问题描述

大家好...！
请帮助我解决我的问题.

我已经开发了工资软件.在这里，我有一个带有员工信息及其工资结构的Excel工作表.我在做什么是我设计了一种表单，在该表单中，我让用户选择Excel工作表，然后将数据从Excel工作表传输到我的数据库.它运行正常，没有错误.

我唯一的问题是我在传输数据时无法显示进度栏.我已经将所有代码写到了一个类文件中，并在我的表单上单击了按钮，然后调用了该类的函数.

请帮助我........ !!

谢谢&问候

Sanket Patil

Hi To All......!
Please Help Me To Solve My Problem.

I Have Developed A Payroll Software. Here I''ve Excel Sheet With Employee Information With Their Salary Structure. What I am Doing Is I have Designed One Form Where I Make User To Select Excel Sheet And Then Transfer The Data From Excel Sheet To My Data Base. It Is Working Fine Without An Error.

The Only Problem I Have Is I am Unable To Show Progress Bar While Transferring Data. I Have Written All The Code In A Class File And On Button Click Of My Form I Have Call The Function Of That Class.

Please Help Me........!

Thanks & Regards

Sanket Patil

推荐答案

在此实现进度条功能有几种方法
案件.最简单的方法就是利用(隐藏的)iframe(这样，自动使用单独的thead).

因此，您可以实现一个工人" aspx(流程开始
在页面加载时)，并将该工作程序作为iframe控件的src.

然后，工作者使用javascript(称为父母的javascript函数)不时更新进度.

如果您喜欢这个主意，我将进一步详细介绍或提供示例.或者，您也可以通过Google搜索"asp.net iframe长期运行"
例如

There are a few ways to implement progress bar functionality in this
case. On of the easiest is to make use of a (hidden) iframe (and that way, automatically use a seperate thead).

So you could implement a "worker" aspx (process starts
on page load) and put that worker as src of an iframe control.

The worker then uses javascript (calls a parents'' javascript function) to update the progress from time to time.

If you like that idea, i would go more into detail or provide an example. Or you could google for "long running process asp.net iframe"
e.g.

这篇关于将数据从Excel工作表传输到数据库时的进度条的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！