RE: fetching data asynchronously using ado.net dataset

Hi
there is no simple way to do that , what you can do however is to use
DataReader Object and increment your progress bar one step with each record
reader .
DataReader however is a steam so you will not know the count of the rows
before hand so what you need to do it to create two queries for each query
you want to execute . One return the number of rows ( and you get that one
so you know how many steps would be in your progress bar ). the second one
is the actual query you want to execute , then get its result in a reader
and increment your progress bar by one step with each row read.
hope this helps
Mohamed M .Mahfouz
Developer Support Engineer
ITWorx on behalf of Microsoft EMEA GTSC

.

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: Progrssbar Value for SP time taken
    ... Are you calling the SP asynchronously? ... increment your progress bar based on this timeframe. ... Others just increment the bar until it fills and reset it ... William Vaughn ...
    (microsoft.public.vb.database)
  • RE: How to create a Thinking Bar not a Progress Bar
    ... I didn't want a genuine 'progress bar' that updated according to ... Unfortunately once Access started processing that query, VBA seemed ... whatever) again the graphics weren't updated while the query ran, ...
    (microsoft.public.access.modulesdaovba)