Programmically creating filter with RadGridView

[Michael Bouhuys]

Have a RadGridView set up with AutoGenerateColumns="True". The grid is populated by:

    SqlDataAdapter dataAdapter = new SqlDataAdapter();
                dataAdapter.SelectCommand = _sqlCommand;
                DataTable dataTable = new DataTable();
                dataAdapter.Fill(dataTable);
                MRSuserSource = dataTable;

All is well at this point the end-user can use the data filter of the grid to sort on whatever column and whatever data. Using AutoGenerateColumns because based on SQL database the number of columns will be more or less.

Looking to create specific filters.

Using some samples and documentation running into a problem on how to do the "column programmatically" as seen in this document "https://docs.telerik.com/devtools/wpf/controls/radgridview/filtering/programmatic#filtering-single-column".

The question becomes how is to define the filter when the columns are automatically created and getting the DataTable to be seen as "GridViewColumn". Maybe missing other details that are being overlooked.

[Vladimir Stoyanov]

Hello Michael,

May I ask you some questions in order to better assist you? Can you specify what problems you have encountered while attempting to filter a column programmatically? In general even though the columns are auto generated, you should be able to apply the approach described in the Programmatic Filtering article that you referenced. Moreover may I ask you to specify what you mean by "getting the DataTable to be seen as "GridViewColumn""? Please note that even though the RadGridView is bound to a datatable, it will create gridviewcolumns and you should be able to filter them as suggested in the article above. 

That said if you still have any problems may I ask you to explain in more detail what you are trying to achieve? You can also open a new support ticket and attach a sample project demonstrating the exact scenario.

Regards,
Vladimir Stoyanov
Progress Telerik