Database Progress Bar

[NuBBeR]

Does anyone have a good idea of how to display a rather accurate progress
bar to show how far along a query is? I am executing multiple queries and
would like to have something graphical for the user to see that the program
is still working. Thanks in advance!

[Nicholas Paldino [.NET/C# MVP]]

NuBBeR,

Unfortunately, there really isn't a way to do this (for most DBs, SQL
Server being one of them).

If you have multiple queries executing, then you can give a progress
indicator for the overall operation (over the multiple queries), but not for
the progress of the individual query.

You can still provide something to indicate that the application is
alive. For example, take the search progress bar in windows (it bounces
back and forth, just to indicate it is doing something).

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"NuBBeR" <be***********@hotmail.com> wrote in message
news:eC**************@TK2MSFTNGP09.phx.gbl...

Does anyone have a good idea of how to display a rather accurate progress
bar to show how far along a query is? I am executing multiple queries and
would like to have something graphical for the user to see that the
program is still working. Thanks in advance!

[NuBBeR]

Nicholas-
Thank you for the feedback! Where can i find the search progress bar?

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> wrote in
message news:uJ**************@TK2MSFTNGP14.phx.gbl...

NuBBeR,

Unfortunately, there really isn't a way to do this (for most DBs, SQL
Server being one of them).

If you have multiple queries executing, then you can give a progress
indicator for the overall operation (over the multiple queries), but not
for the progress of the individual query.

You can still provide something to indicate that the application is
alive. For example, take the search progress bar in windows (it bounces
back and forth, just to indicate it is doing something).

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"NuBBeR" <be***********@hotmail.com> wrote in message
news:eC**************@TK2MSFTNGP09.phx.gbl...

Does anyone have a good idea of how to display a rather accurate progress
bar to show how far along a query is? I am executing multiple queries
and would like to have something graphical for the user to see that the
program is still working. Thanks in advance!

[W.G. Ryan eMVP]

If you're using Sql Server you can trap the InfoMessage event (include some
print statement and even though they aren't error messages, they'll come
back and you can bump the progress bar)

--
W.G. Ryan, MVP

www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"NuBBeR" <be***********@hotmail.com> wrote in message
news:eC**************@TK2MSFTNGP09.phx.gbl...

Does anyone have a good idea of how to display a rather accurate progress
bar to show how far along a query is? I am executing multiple queries and
would like to have something graphical for the user to see that the program is still working. Thanks in advance!