RadGridView Delete Rows where Column value in a Set

[Howard]

Rather than looping through the rows, testing a cell value and determining if that value is NOT and should be deleted, is there a query against the control I can use to do the same thing?

Conceptually:

delete from radGridView1 where column["ID"].Value not in set (can be a list or some other collection)

Thanks

[Stefan]

Hi Howard,

Thank you for writing.

The best way to achieve your scenario is to loop through the grid rows and remove the one that does not meet your criteria. If you want to prevent updating the grid with every deleted row, you can place your deletion logic in a DeferRefresh using:

using (radGridView1.DeferRefresh())
{
    //deletion logic here
}

I hope this helps.

All the best,
Stefan
the Telerik team