Your problem is not cosmetic, IMHO. It's a very basic problem that is
encountered by every new developer. That is the time for the said
developer to research "multithreading".

On Feb 8, 12:02 pm, "Joe C." <[email protected]> wrote:
> thank you for reading.
>
> i have a windows application, a tool built to take large text files
> (containing data) to import into a sql server table.
>
> the text files contain more than 300,000 lines of data at a time.
>
> vb.net code in the windows application reads each line, parses, then
> inserts into the database table.
>
> on the form i have set a label to show the progress of the data
> migration, and a progress bar reflecting percentage finished.
>
> problem is, during the loop, if the form is moved or focus taken away
> from the form, the form itself freezes.  the progress bar no longer
> moves forward, and label also stops showing any updates.
>
> but the background process, of reading the text line, then inserting
> into sql, still runs and eventually the entire process will finish.
>
> so my problem is a cosmetic one, i would like to form to continue
> updating the information while the long running loop is completed.
>
> any help would be greatly appreciated.
>
> - Joe

Reply via email to