Re: Progrssbar Value for SP time taken

Tech-Archive recommends: Speed Up your PC by fixing your registry

Are you calling the SP asynchronously? Even if you are there is no way to
tell how long anything will run except by experience. For example, how long
does it take for you to get to work? You have a pretty good idea because you
go there every day under varying conditions. Knowing how long an SP will
take is about the same. It might take 3-20 seconds to execute so you could
increment your progress bar based on this timeframe. Some MS apps uses the
"exponential" approach. It bumps up the progress bar half the distance left
every few seconds. Others just increment the bar until it fills and reset it
to 0 to start over.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"DMP" <debdulal.mahapatra@xxxxxxxxxxxx> wrote in message
news:OLHgo$MQFHA.2932@xxxxxxxxxxxxxxxxxxxxxxx
> Hi,
> I call a Stored Procedure(SQL-Server) from my VB Application
> and showing process on a progressbar.But I don't know how much time taken
> by SP.
> That is why I cannot show Progressbar value propotionately.
> How can i increse progressbar value properly ?
> Regards,
>


.

Relevant Pages

  • Common Control - Progress Bar Problem
    ... I am having problems getting a progress bar on a dialog window to increment ... BOOL CALLBACK ProgressDialogProc(HWND hwnd, UINT message, WPARAM wParam, ... LPARAM lParam) ...
    (microsoft.public.win32.programmer.ui)
  • Re: Form - with Progress Bar
    ... progress bar step by step as you propose. ... doevents command in the loop also update the display). ... to probably going to have is you can run is looping code to increment the ... will star waiting for the report. ...
    (microsoft.public.access.reports)
  • Re: Drawing custom progress bar and threading
    ... messageboard posts at EggHeadCafe.com. ... > Everything seems to work fine, except that when the progress bar control ... > every increment, will this cause it to be resource hungry? ...
    (microsoft.public.dotnet.framework.drawing)
  • RE: fetching data asynchronously using ado.net dataset
    ... DataReader Object and increment your progress bar one step with each record ... before hand so what you need to do it to create two queries for each query ... is the actual query you want to execute, then get its result in a reader ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Hlep One More Time Modeless Dialog
    ... member variables of the class. ... You should not be calling any function outside the dialog, and in particular, you must not ... Then you introduce some boolean variable to tell if you have a progress bar, ... See my essays on threading on my MVP ...
    (microsoft.public.vc.mfc)