How to verify if a DataGridViewCheckBoxCell is Checked

Question

I have bound a data table to a DataGridView, this data table has a column called "Status" which is of type Boolean. I can set the value to true or false just fine via code.

However, I can't figure out how to check to see if the given row is already checked or not. This is the code I am trying to use and compiling it shows the error "the specified cast is invalid".

Any help would be appreciated.

if (rowIndex >= 0)
{
    var cbxCell = (DataGridViewCheckBoxCell)dgvScan.Rows[rowIndex].Cells["Status"];

    if ((bool)cbxCell.Value)
    {
        // Do stuff
    }
    else
    {
        // Do other stuff
    }
}

You have two casts in your example code. Which one is causing the error? Casting the cell to a DataGridViewCheckBoxCell or casting the value to a bool? — Jason Berkan, Oct 13 '09 at 22:18
Perhaps not entirely related to this question, but this may help: https://stackoverflow.com/a/48465766/5750078 — Alvaro Rodriguez Scelza, Jan 26 '18 at 17:51

score 12 · Answer 1 · answered Oct 06 '16 at 16:33

Thank you all. Had the same problem but i find out that writing senderGrid.EndEdit(), before checking the value, resolves it.

private void dgvRiscos_CellContentClick(object sender, DataGridViewCellEventArgs e)
    {
        var senderGrid = (DataGridView)sender;
        senderGrid.EndEdit();

        if (senderGrid.Columns[e.ColumnIndex] is DataGridViewCheckBoxColumn &&
            e.RowIndex >= 0)
        {

            var cbxCell = (DataGridViewCheckBoxCell)senderGrid.Rows[e.RowIndex].Cells["associado"];
            if ((bool)cbxCell.Value)
            {
                   // Criar registo na base de dados
            }
            else
            {
                   // Remover registo da base de dados
            }
        }
    }

Keep up the good work

If I can upvote infinite times I would do it for this answer, i've been struggling with this issue but your answer did it. Super-massive respect! — 3bdalla, Aug 08 '17 at 05:37

Mark Ainsworth · Answer 2 · 2014-01-07T22:09:59.197

The problem is that the default FALSE value for a DataGridCheckBoxColumn is null, and the Default TRUE value is the boolean value True. This causes a problem because boolean values are not nullable. You can solve this problem two ways:

    if (cbxCell.Value != null && (bool)cbxCell.Value)
    {
        do stuff;
    }

The other way to solve this is set the TrueValue property of the column to some value. This can be done at design time as shown:

enter image description here

Then you can write:

    if ((string)cbxCell.Value == "T")
    {
        do stuff;
    }

This works because Strings are nullable.

Please note: Even though I set the FalseValue to be F the false value still seems to be null, so I suggest ignoring the FalseValue property.

One other note: IF you put something in TrueValue as above and then attemp to erase it, True value becomes null (ouch), requireing you to delete the column and then re-add it in order to restore it to the default condition. Or you can change it in code as follows:

((DataGridViewCheckBoxColumn)DataGridView1.Columns["Selected"]).TrueValue = true

it's a bit strange looking, but `true.Equals(cbxCell.Value)` is ok with `null`, `DBNull.Value`, and the default boolean `true` value. — Slai, Nov 26 '16 at 07:17

score 1 · Answer 3 · answered Nov 30 '13 at 06:12

1

 if (Convert.ToBoolean(dgvScan.Rows[rowIndex].Cells["Status"].Value))
{
//Do Something
}
else {
// Do Something
}

answered Nov 30 '13 at 06:12

senthilkumar2185

2,536
3
22
36

score 1 · Answer 4 · edited May 23 '17 at 10:31

Another issue that may be encountered is this:

When the user clicks the cell to check or uncheck the box, the underlying value will not be changed until the cell loses focus.

This will not be an issue if the code in question is in a button, since the cell will lose focus when you click the button. But if your code is fired from a timer, you may still be checking the 'old' value.

See my other answer here: https://stackoverflow.com/a/22080846/1015072

score 0 · Answer 5 · answered Oct 13 '09 at 22:23

0

I have no prior experience in this, but I guess you should check the value of the column or property.

Try to have a look to this example:

http://programmingwithstyle.blogspot.com/2007/06/how-to-get-from-datagridviewcheckboxcel.html

answered Oct 13 '09 at 22:23

Roberto Aloi

30,570
21
75
112

score 0 · Answer 6 · answered Oct 13 '09 at 22:50

0

CbxCell.Value must be equal to DBNull.Value (your column can contain null values right?)

I would check for DBNull before casting:

if (!DBNull.Value.Equals(CbxCell.Value) && (bool)CbxCell.Value == true)
{
    //Do stuff
}
else
{
    //Do Stuff
}

answered Oct 13 '09 at 22:50

manji

47,442
5
96
103

score 0 · Answer 7 · answered May 25 '15 at 15:54

0

bool checked = cell.Value as bool? ??  false;

answered May 25 '15 at 15:54

John

1,011
11
18

How to verify if a DataGridViewCheckBoxCell is Checked

7 Answers7

Linked