How to link a progressbar with datagridview

Question

0.00/5 (No votes)

See more:

Hi I'm trying to link a progressbar with datagridview when a button is clicked.The problem is that the datagridview is fetched before the progressbar starts to run.

How can i edit my code so that the progressbar show me the progress while the datagridview is fetch / filled.
I'm using a Backgroundworker.

C#

/* Backgroundworker for the progressBar*/
            private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
            {
                int sum = 0;
                //for (int i = 1; i <= 100; i++)
                    for (int i = 0; i < datagridview1.Rows.Count - 1; i++)
                {
                    Thread.Sleep(10);
                    sum = sum + i;
                    backgroundWorker1.ReportProgress(i);
                    if (backgroundWorker1.CancellationPending)
                    {
                        e.Cancel = true;
                        backgroundWorker1.ReportProgress(0);
                        return;
                    }
                }

                e.Result = sum;
            }

The Button function:

C#

  private void btnShow_Click(object sender, EventArgs e)
    {
        progressBar1.Visible = true;

        if (cb1.SelectedItem != null && cb2.SelectedItem != null)
        {
            string C = ConfigurationManager.ConnectionStrings["D"].ConnectionString;
            SqlConnection con = new SqlConnection(C);
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = con;
            cmd.CommandText = ("[dbo].[spData]");
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@Table_Name", cb1.SelectedValue.ToString());
            cmd.Parameters.AddWithValue("@Table_Name2", cb2.SelectedValue.ToString());
            SqlDataAdapter adapter = new SqlDataAdapter(cmd);



if (cb1.SelectedValue.ToString() != null && cb2.SelectedValue.ToString() != null)
            {
                try
                {

                    con.Open();
                    dt = new System.Data.DataTable();
                    adapter.Fill(dt);
                    //datagridview1.AutoGenerateColumns = true;
                    datagridview1.DataSource = dt;
                    lbtblCount.Text = cb1.Text + " Anzahl : " +  datagridview1.Rows.Count.ToString();

                }

                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
                finally
                {
                    con.Close();
                }

            }

        }
        else
        {
            MessageBox.Show("Safety check");
        }

        // Check if the backgroundworker is already busy running the asynchronous operation
        if (!backgroundWorker1.IsBusy)
        {
            //This method will start the execution asynchronously in the background
            backgroundWorker1.RunWorkerAsync();
        }
        else
        {
            label7.Text = " Busy processing, please wait";
        }
    }

Would be glad for an help

Posted 1-Feb-15 23:15pm

mikybrain1

Updated 1-Feb-15 23:57pm

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Varun_Kumar · Answer 1 · 2015-02-02T01:52:00

Solution 1

Please check

BackgroundWorker Class Sample for Beginners[^]

Posted 2-Feb-15 1:52am

Varun_Kumar

Comments

mikybrain1 2-Feb-15 8:13am

Thanks for the link BUT my question was how can i connect it properly with my datagridview.

Varun_Kumar · Answer 2 · 2015-02-03T20:16:00

Hi,

Here a sample check this

C#

public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        BackgroundWorker bw;
        bool isGetDataFromDb = false;
        int progressCount = 0;

        private void button1_Click(object sender, EventArgs e)
        {
            dataGridView1.Rows.Clear();
            dataGridView1.AutoGenerateColumns = false;
            this.progressBar1.Value = 0;
            bw = new BackgroundWorker();
            bw.DoWork += (s, se) => 
            {
                se.Result = FillDatagRide();
                isGetDataFromDb = true;
            };
            bw.ProgressChanged += new ProgressChangedEventHandler(bw_ProgressChanged);
            bw.RunWorkerCompleted += new RunWorkerCompletedEventHandler(bw_RunWorkerCompleted);
            bw.WorkerSupportsCancellation = true;
            bw.WorkerReportsProgress = true;
            bw.RunWorkerAsync();

            //just to show progress bar till data get from db.
            for (int i = 1; i < 50; i++)
            {Thread.Sleep(50);
                
                if (isGetDataFromDb)
                {
                    break;
                }
                bw.ReportProgress(++progressCount);
            }

        }

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

        void bw_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
        {
            ArrayList result = e.Result as ArrayList;
            foreach (var item in result)
            {
                Thread.Sleep(100);
                this.progressBar1.Value = ++progressCount;
                Invoke((MethodInvoker)(() => dataGridView1.Rows.Add(item)));
            }

            this.progressBar1.Value=100;
        }

        private ArrayList FillDatagRide()
        {
            //Code Get data from db
            Thread.Sleep(1000);
            return new ArrayList();//contain data from db 
        }
    }