Pre-defining items for the column filter?

[Alex]

Let's say I have a very large (millions of records) DB of cars but one of the column (colors) has only a couple of different choices (red, green, blue, black, white).

When I'm binding the DB to the GridView (using pagination because I can't load the whole table at once and data virtualization is performing poorly on this amount of data) and trying to filter by color every time I open the filter editor I'm sending a query to my DB asking for Top 1000 Distinct colors which is really slow.

Now my question is, can I have a predefined list of available colors to use for my Filter Editor? Just create a List<String> and feed it to the editor?

Thank you.

[Dilyan Traykov]

Hello Alex,

You can use RadGridView's DistinctValuesLoading event in order to filter the displayed distinct values. Here's an example:

private void RadGridView_DistinctValuesLoading(object sender, Telerik.Windows.Controls.GridView.GridViewDistinctValuesLoadingEventArgs e)
{
    if (e.Column == this.RadGridView.Columns["Color"])
    {
        e.ItemsSource = TopColors;
    }
}

Please let me know if this works for you.

Regards,
Dilyan Traykov
Telerik by Progress

[Alex]

Thank you Dilyan, this was exactly what I was looking for.