c# winform - how to delete multiple DataGridViewRows

Memento

Here is m code:

foreach (DataGridViewRow r in dgv01.Rows)
       if (r.Cells[0].Value.ToString() == abc)
       {
        dgv01.Rows.Remove(r);
        //dgv01.CurrentCell = dgv01.Rows[0].Cells[0]; - also tried
        }

But only some rows are deleted - not all specified !?

Why - foreach - does not mean - foreach ?

2 Replies

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

Jignesh Trivedi14y ago
Accepted answer
hi,

you can also use RemoveAt method.
try..

for(var i=0;i<=dgv01.Rows.count-1;i++)
{
DataGridViewRow r = dgv01.Rows[i]
        if (r.Cells[0].Value.ToString() == abc)
        {
           dgvEmployee.Rows.RemoveAt(i);
        }
}

you can also do one thing remove that row from datasource i.e data table or collection.

Examle if you data set to bind datagrid then

Dataset dataset = dgv01.DataSource as Dataset;
for(var i=0;i<=dataset.Tables["Employees"].Rows.count-1;i++)
{
DataRow r = dataset.Tables["Employees"].Rows[i]
        if (r.Cells[0].ToString() == "abc")
        {
           dataset.Tables["Employees"].Rows[i].Delete();
        }
}
hope this will help u.
Memento14y ago
Jignesh, thanks aLot.

I just replaced your loop by an reverse loop and - it works:

for (int i = dgv01.Rows.Count - 1; i >= 0; i--)

ThanksAgain!