how to use progress bar to indicate database progress

Question

0.00/5 (No votes)

See more:

I want to use a progress bar to indicate that the windows form is accessing the database and processing the enquire, but i dont know how to set the maximum, since i don't know how long the database is going to take to perform the enquire, can anyone shed some light here ,thanks.

Cheers

Posted 22-Apr-11 21:57pm

uranusliao

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

OriginalGriff · Answer 1 · 2011-04-22T22:13:00

No. We can't. We don't know either.

How long is a piece of string?

How much data are you fetching? How fast is your server? What is the connection like? Are you returning the result of a simple query or a complex stored procedure? What is your server load like at the moment of the query? These and other factors will affect the time taken.

You can force SQL server to give you a progress indication, but it isn't simple, and may be more trouble than it is worth - there is an explanation here: http://geekswithblogs.net/mrnat/archive/2004/09/20/11431.aspx[^]

Note that you will need a separate thread, and that you will have to take care of cross-thread Invokes to update the status bar!

"Thanks for your quick response, does it mean no simple solution for that?
how can i tell the users that the programming is accessing the database and doing the job rather than nothing shows up"

There is no simple, accurate solution, no. You can show progress if you follow the link I gave, but the only other thing you can do is to move the query to a separate thread and display on non-specific progress indicator - asynchronous SQL is also quite complicated, so I wouldn't recommend it for simple queries. It needs to be a separate thread so that the UI can be updated to actually show the progress change, otherwise your UI will "jam" in the ExecuteReader method call or whatever!