Show progress bar in windows forms application

See more:

C#

WPF

forms

hi

i want to use progress bar in my windows form application.

i tried using BackgroundWorker from this link http://eclipsed4utoo.com/blog/windows-form-progressbar/[^].

In my form on button click it downloads data from SQL database to XML file, it takes 8 to 10 sec for data downloading.in that time i would like to show progress bar.
here problem is progress bar is showing after code downloaded from SQL to XML.

here is the code below

bgw = new BackgroundWorker();
     bgw.WorkerReportsProgress = true;
     bgw.ProgressChanged += new ProgressChangedEventHandler(bgw_ProgressChanged);
     bgw.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bgw_RunWorkerCompleted);
     bgw.DoWork += new DoWorkEventHandler(bgw_DoWork);

       private void btnSubmitEventId_Click(object sender, EventArgs e)
        {
 
        bgw.RunWorkerAsync();  // called RunWorkerAsync in my button click

       // here my code for data downloading

        }



    void bgw_DoWork(object sender, DoWorkEventArgs e)
   {
    for (int i = 0; i < 10; i++)
    {
        bgw.ReportProgress((i + 1) * 10);
        Thread.Sleep(1000);
    }
   }

      void bgw_ProgressChanged(object sender, ProgressChangedEventArgs e)
     {
        progressBar1.Value = e.ProgressPercentage;
     }

     void bgw_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
     {
     MessageBox.Show("Finished");
     }


here i understand that ReportProgress raises the bgw_ProgressChanged and assigned progress ercentage to  progressBar1.Value that is fine but here  ReportProgress raises bgw_ProgressChanged method after my data downloading is completed.

plz help me to find this out.