How to use Progressbar with BackGroundWorker

Question

Is there any idea on how to animate Marquee mode Progressbar while connecting to remote database, maybe running Progressbar in a separate tread in order to run them simultaneously in two different tasks.

Vulpes · Answer

Well, the long-running operation here is connecting to the database. So, to prevent your UI from freezing, you need to put the code to do that in the DoWork method, along with the calculations to update the ProgressBar. At the moment you have the database operations in the button1_Click eventhandler which executes on the UI thread.

Vulpes · Answer

It sounds like a job for the BackgroundWorker class. In fact there's an example which uses the ProgressBar in the MSDN docs: http://msdn.microsoft.com/en-us/library/system.componentmodel.backgroundworker.aspx

Samio · Answer

That's it, Many thanks Vulpes.

Samio · Answer

I found the next code that I modified to add the database connection, but still cannot run them both simultaneously (Progressbar stops untill connection is completed) : public partial class FrmBackGroundWorker : Form { BackgroundWorker bgw = new BackgroundWorker(); dbDataContext db; public FrmBackGroundWorker() { InitializeComponent(); label1.Text = ""; label2.Text = ""; } private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { int total = 57; //some number (this is your variable to change)!! for (int i = 0; i { System.Threading.Thread.Sleep(100); int percents = (i * 100) / total; bgw.ReportProgress(percents, i); } } private void backgroundWorker1_ProgressChanged(object sender, ProgressChangedEventArgs e) { progressBar1.Value = e.ProgressPercentage; label1.Text = String.Format("Progress: {0} %", e.ProgressPercentage); label2.Text = String.Format("Total items transfered: {0}", e.UserState); } private void backgroundWorker1_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) { //do the code when bgv completes its work } private void button1_Click(object sender, EventArgs e) { progressBar1.Style = ProgressBarStyle.Marquee; bgw.DoWork += new DoWorkEventHandler(backgroundWorker1_DoWork); bgw.ProgressChanged += new ProgressChangedEventHandler(backgroundWorker1_ProgressChanged); bgw.RunWorkerCompleted += new RunWorkerCompletedEventHandler(backgroundWorker1_RunWorkerCompleted); bgw.WorkerReportsProgress = true; bgw.RunWorkerAsync(); //Connection to database: db = new dbDataContext(); var Users = from p in db00.Users where p.UserName == TxtUser.Text select p; foreach (var record in Users) { Global._UserName = record.UserName; Global._UserID = record.ID; } label3.Text = "User ID = " + Global._UserID; } } }

How to use Progressbar with BackGroundWorker

Answers (4)