Devexpress ASPxGridView how to hide rows where first column value is "Deleted"?

Question

Windows

You want to hide rows where the value "Deleted" is in the first column.
I found the code, but it is for XtraGrid:
using DevExpress.XtraGrid.Views.Base;
using DevExpress.XtraGrid.Columns;
//...
ColumnView view = gridView1;
view.ActiveFilter.Add(view.Columns["CategoryName"],
new ColumnFilterInfo("[CategoryName] Like 'c%'", ""));
Who faced such a task?
I'm using version 15.2.
Asp.net web forms.

Answer 1

I would advise you to do it easier - your query should filter the lines that contain the word you don't need. Let's say in SqlDataSource use a query like:

SELECT *
FROM Categories
WHERE CategoryName NOT LIKE 'c%';

You thereby transfer less data to the server in order to render the page.