473,324 Members | 2,511 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

how to run progress bar while executing a long method or an update statement?

3
Hi,

I am unable to crack this as the end user requested to show some kind of progress bar while running a long time method or an update statement. Kindly suggest me on this ASAP.

Rgds,
TSKMJK
Nov 6 '09 #1
5 5630
tlhintoq
3,525 Expert 2GB
I am unable to crack this
Obviously you have already been working on this. What do you have so far?
Nov 6 '09 #2
tskmjk
3
Hi,

I have developed a vb.net application with MySQL as backend. Its a data massaging tool where it takes excel sheet as input and processes its data. During this long operations, end user asked to have a progress bar so that the progress can be known. But I am unable to do this as its a series of update sql statements which takes a long time and I am unable to run progress bar for this.

Kindly help

Rgds
TSKMJK
Nov 6 '09 #3
Plater
7,872 Expert 4TB
The long executing process should be run in a seperate thread.
Then you are free to update the progressbar as you like.
I recomend incrementing the bar by "task" and not by time. Much easier to estimate that way.
Nov 6 '09 #4
tlhintoq
3,525 Expert 2GB
If the processing is being handled by a program you wrote and are in control of, you could add an event that gets raised during each pass. That way your progress bar can receive the event and update.... 154 of 12,000 .....

But if the process is all contained in the MySQL database... I don't know what to tell you. Processing is happening inside a closed system.

this as its a series of update sql statements
I recomend incrementing the bar by "task" and not by time.
If you are in control of the series of SQL statements (each statement comes from your program, then Plater's suggestion makes the most sense.... Step 1 of 5....
Nov 6 '09 #5
Curtis Rutland
3,256 Expert 2GB
I suggest you use a BackgroundWorker to handle your long database commands. That way, the UI thread isn't blocked and you can update graphical elements.
Nov 9 '09 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

16
by: Paul | last post by:
i have been working with vb6 for a while but never had the pleasure of using progress bars. That is until now, one of the programs i have written has just been modified so that large csv files of...
3
by: Andrew | last post by:
I'm doing a big old join on one table with 10,000,000 rows, and another with 400,000 rows. As you can imagine, this is taking a long time. Is there any way to monitor the progress of the join...
3
by: Brian Birtle | last post by:
**** A CHALLENGE TO THE GURUS - refute the statement "It's impossible to build a file upload progress meter using ASP.NET" **** First person to prove me wrong gets "All Time .NET Programming GOD"...
3
by: Vinay | last post by:
Hello I am trying to update a Progress bar on a form. I am able to update it via using a simple clock timer, but as soon as I perform a long operation G1 (generation of a report) in a separate...
0
by: Igor | last post by:
Hi all, I've had these pages that I wrote in php that are used for executing varoius queries. Query results are displayed as tables. Since these tables can be pretty big I'like to give user some...
9
by: no | last post by:
Hi I have a PHP script that updates a very large table and in the code I echo some text to show the progress of the update but the text only appears when the page has finished displaying. Is...
5
by: Miro | last post by:
I will try my best to ask this question correctly. I think in the end the code will make more sence of what I am trying to accomplish. I am just not sure of what to search for on the net. I...
1
by: Bob | last post by:
Hi, I am having trouble seeing how this bolts together. The UI starts a process which involves a long running database update. All Database activity is handled by a class called DT. DT has a...
23
ADezii
by: ADezii | last post by:
Many Access Users fail to realize that it has a built-in Progress Meter that can display the relative completion percentage of various processes. It is fairly limited, but nonetheless, does provide...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.