select sql query and show in progress bar?

Question

5.00/5 (1 vote)

See more:

C#

hi, my database have many records .and i want select it , i want show it in progress bar when select records, what do?

Posted 15-Aug-11 7:13am

javad_r_85

Updated 15-Aug-11 7:22am

v2

Add a Solution

Comments

Manfred Rudolf Bihy 15-Aug-11 13:43pm

Please edit your question and add more details about what your progress bar is supposed to indicate.
If you want to indicate that an SQL statement is still running you should probably use something other than a progress bar. In order to show true progress you'd need some indication how much of the work has already been done. If this information can not be acquired your best bet would be to use some sort of activity indicator.

Wendelius 15-Aug-11 14:03pm

Why not marquee style progress bar? http://msdn.microsoft.com/en-us/library/system.windows.forms.progressbarstyle.aspx[^]

Manfred Rudolf Bihy 21-Aug-11 7:34am

MS might have squeezed a Marquee style into a progress bar, which still doesn't make it a progress indicator, but rather an indicator that somthing is happending. The essence of what I'm saying is that when true progress can not be measured any kind of available activity indication would do, but I should not trick the user into thinking that there is in fact some kind of progress that is being tracked.

Cheers!

4 solutions

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)

Wendelius · Answer 1 · 2011-08-15T07:47:00

In order to do that you would have to execute the select asynchronously and in the meantime show some kind of indication that the query is in progress.

One way to do the fill asynchronously is to use BackgroundWorker [^]. So basically you would put the data adapter fill (or whatever you use) in the DoWork event.

A side note: Since users are typically not very willing to wait for long times I would put most of the effort to enhancing the query performance, if possible and use the progress indicator as 'the last option'. Just having many records doesn't mean that the queries are automatically slow. That maybe for example because of inadequate indexing.

luisnike19 · Answer 2 · 2011-08-15T07:49:00

Solution 2

I'm not sure what do you have to do, but you could check this article Showing progress bar in a status bar pane[^] and display your query

Posted 15-Aug-11 7:49am

luisnike19

Abhinav S · Answer 3 · 2011-08-15T07:55:00

Solution 3

This post[^] might help.

Posted 15-Aug-11 7:55am

Abhinav S

#realJSOP · Answer 4 · 2011-08-15T08:04:00

Unless you retrieve the records one at a time (what a huge waste of time and bandwidth), a progress bar is going to be fairly pointless (in the normal sense of the word "progress").

What you want is some indication that the process is running, because when you retrieve a bunch of records all at once, there's no progress being reported. At the same time, you don't necessarily want the UI in your app to freeze up while you're waiting for the database transaction to complete. This means that you need to run your query from a thread, and put make your ProgressBar a marquee style (progressbar1.Style = ProgressBarStyle.Marquee;), and put it in your StatusStrip control.

select sql query and show in progress bar?

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0