C# Check if any checkbox in datagridview is checked

Question

When I check a checkbox in dataGridView, the checkbox that I've checked is automatically becoming false because I am refreshing my dataGridView every second. What I want to happen is to cancel the refreshing every second when a dataGridView checkbox is checked.

Here is my code:

private void UpdateVisitors_Load(object sender, EventArgs e)
{
    //Realtime refresh
    refresher.Interval = (1 * 1000); // 10 secs
    refresher.Tick += new EventHandler(refresh);
    refresher.Start();
}

private void refresh(object sender, EventArgs e)
{
   refreshLocal();
}

UPDATE Here is my refreshLocal code that I've been using to refresh my dataGridView

 void refreshLocal()
    {
        dgvLocal.Rows.Clear();
        connection.Close();
        connection.Open();

        SqlCommand cmd = connection.CreateCommand();
        cmd.CommandText = "Select * from tbl_Registration ORDER BY [ID] DESC;";
        SqlDataAdapter adap = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        adap.Fill(ds);
        foreach (DataRow dr in ds.Tables[0].Rows)
        {
            myID = dr["ID"].ToString();
            category = dr["Category"].ToString();
            repname = dr["Representative"].ToString();
            if (dr["City/Province"].ToString() == "")
            {
                city = dr["Province"].ToString();
            }
            else
            {
                city = dr["City/Province"].ToString();
            }
            pax = dr["Pax"].ToString();
            male = dr["Male"].ToString();
            female = dr["Female"].ToString();
            students = dr["Students"].ToString();
            ar = dr["AR Users"].ToString();
            date = dr["Date & Time Added"].ToString();
            dgvLocal.Rows.Add(false, myID, category, repname, city, pax,students, ar, date);
        }
        connection.Close();
    }

Maybe place your "datagrid stopping checkbox" outside of you datagrid? — SᴇM
– SᴇM, Commented Sep 28, 2018 at 12:54
Possible duplicate of How to check if dataGridView checkBox is checked? — Pvria Ansari
– Pvria Ansari, Commented Sep 28, 2018 at 12:57
I dont know what do you do in refreshLocal , but maybe you can set true to source data before binding if related record is checked — Mehmet Emin Yalçın
– Mehmet Emin Yalçın, Commented Sep 28, 2018 at 12:58
Most of that code is not needed. Using databinding, there is no need to tediously populate each row and using a persistent DataAdapter, you can set it up to do actual refreshes of the data — Ňɏssa Pøngjǣrdenlarp
– Ňɏssa Pøngjǣrdenlarp, Commented Sep 28, 2018 at 14:21

Paradise228 · Accepted Answer · 2018-09-28 15:06:32Z

1

You need to bind to the event CellValueChanged of your DataGridView and inside the handler, stop your timer depending on the value of your checkbox.

private void dataGridView_CellValueChanged(object sender, DataGridViewCellEventArgs e) {
    if (dataGridView.Columns[e.ColumnIndex].Name == "MyCheckBoxCellName" && dataGridView.Columns[e.ColumnIndex].Value) {
        // Disable your Timer
        refresher.Enabled = false;
    }
}

answered Sep 28, 2018 at 15:06

Paradise228

7173 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

C# Check if any checkbox in datagridview is checked

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related