SQL to FilterDescriptor?

  this.radGridView1.FilterDescriptors.Expression = @"[ProductName] LIKE '%w%' AND [ProductID] > 2";

As a result, the RadGridView.FilterDescriptors collection will be populated and the grid data will be filtered. If you want to load the data parsed form the expression to the filter row, you can use the following code snippet: 

            foreach (FilterDescriptor fd in this.radGridView1.FilterDescriptors)
            {
                fd.IsFilterEditor = true;
            }

I hope this information helps. If you need any further assistance please don't hesitate to contact me. 

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik

Thank you, this almost works, however, here is the problem. The now filtered grid does not visually appear filtered - that is the filter indicators in the column headers don't show that a filter is present - and you cannot get the column's filter from the column's FilterDescriptor. This means that the application of the filter in the way you suggest does not restore the grid to the state that is functionally and visually identical to the one that would be achieved by manual application of the filters.

I know that setting individual columns' FilterDesriptors would have worked - the grid  would appear visually fitered - but unfortunately the individual columns FilterDescriptor.Expression property is not settable!

Do you have any suggestions?

After using this code for a few days I realized that something strange is still going on. So, indeed the filtering works as described above. However! the filter indicator in the column does not appear right away. Instead, it appears only when I horizontally scroll in the grid!

The two screenshots demonstrate this - the yellow indicator is only there after I scrolled to the right my grid. 

To be clear - the filter itself got applied and is working - only the fact that the indicator is not yellow is the problem

Can you suggest a fix?

        private void radButton1_Click(object sender, EventArgs e)
        {
             this.radGridView1.FilterDescriptors.Expression = @"[ProductName] LIKE '%w%' AND [ProductID] > 2";

            foreach (FilterDescriptor fd in this.radGridView1.FilterDescriptors)
            {
                fd.IsFilterEditor = true;
            }
            this.radGridView1.MasterTemplate.Refresh();
        }

This is expected to do the trick. Please give it a try and see how it works on your end.

Should you have further questions please let me know.

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik