Updating a progress bar with 2 database connections
I am inserting data into SQL Server with 1 connection (Project 1)and trying to create another connection doing a select statement (no lock) to update the progress bar whille connection 1 is inserting. I noticed I had to move the other connection to another thread (DLL Project) with a timer, but the progress bar only runs after the insert is done. It appears as if the Progress bar will not work inside Project 1.
I think I need to move the progress bar into the DLL project then pass it back in (progress bar object) to another progress bar on Project 1. If anyone has any suggestions how to do this please let me know.
Thanks