G
Guest
Hi,
I have a simple Windows Forms app that connects to a SQL server, extracts
about 50,000 records and saves them to a file. During the query, I have a
small bit of text on a status bar that increments a period (.) every second
to show the user that the app is still running and not hung. I have used
timers, timer threading and system threading to increment the "dot" in a
separate thread with no problem UNTIL I execute the query using
SQLDataAdapter. While the query proc is being run the dots just stop
incrementing..As soon as the query is done, the dataset is filled, the "dots"
begin to increment again. Not what I intended. It seems that the UI thread is
still running but never gets enough CPU time to update the status bar on the
screen. Is there anyway to give that UI updating thread enough time to update
the screen or do I have to run the SQL Query routine in it's own thread. Any
help would be greatly appreciated ?
Max
I have a simple Windows Forms app that connects to a SQL server, extracts
about 50,000 records and saves them to a file. During the query, I have a
small bit of text on a status bar that increments a period (.) every second
to show the user that the app is still running and not hung. I have used
timers, timer threading and system threading to increment the "dot" in a
separate thread with no problem UNTIL I execute the query using
SQLDataAdapter. While the query proc is being run the dots just stop
incrementing..As soon as the query is done, the dataset is filled, the "dots"
begin to increment again. Not what I intended. It seems that the UI thread is
still running but never gets enough CPU time to update the status bar on the
screen. Is there anyway to give that UI updating thread enough time to update
the screen or do I have to run the SQL Query routine in it's own thread. Any
help would be greatly appreciated ?
Max