Remove Datagridview Rows That are Checked

mike Delvotti

I have a datagridview where the cells on one column are a checkbox item, I would like to remove (on button click) the checked rows. I think I am nearly there with the below but get the following execption thrown:

'Object cannot be cast from DBNull to other types.'

Below is the code inside the button I'm using:

for (int i = 0; i < supplyDataGridView.Rows.Count; i++)
            {

                if (Convert.ToBoolean(supplyDataGridView.Rows[i]
                                      .Cells[1].Value) == true)
                {
                    supplyDataGridView.Rows.RemoveAt(i);
                }
            }

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes13y ago
Accepted answer
Try it like this:

for (int i = supplyDataGridView.Rows.Count - 1; i >= 0; i--)
{
object temp = supplyDataGridView.Rows[i].Cells[1].Value;
if (!Convert.IsDBNull(temp) && Convert.ToBoolean(temp))
{
supplyDataGridView.Rows.RemoveAt(i);
}
}
0
Upamanyu Roy Choudhury13y ago
HI Mike,

There are many approaches to delete the checked entry in a GridView.

However I personally like the following way most

protected void btnDelete_Click(object sender, EventArgs e)
{
foreach (GridViewRow gvr in GrvDraft.Rows)
{
if (gvr.RowType == DataControlRowType.DataRow)
{
if ((gvr.FindControl("chkChild") as CheckBox).Checked == true)
{
//Your Delete Code
int i = Convert.ToInt32(GrvDraft.DataKeys[gvr.RowIndex].Value);
}
}
}
}

Another way

GVGLCode1.DataSource = dt;
GVGLCode1.DataBind();

int iCount = GVGLCode1.Rows.Count;
for (int i = 0; i <= iCount; i++)
{
    CheckBox cb = (CheckBox)GVGLCode1.rows[i].FindControl("checkBox");
    if (cb != null && cb.Checked)
    {
       GVGLCode1.DeleteRow(i);
    }
}

With Warm Regards,
Upamanyu
0
mike Delvotti13y ago
Nice one Vulpes - thank you.
0