Custom filters and datagrid in devexpress? winforms

[Alexis]

any chance to create a data grid and customs filters like that in devexpress? im moving out from a php app to a c# one, standalone as per client requirement

[Dinko | Tech Support Engineer]

Hello Alexis,

Thank you for your interest in our Telerik UI RadGridView component for WinForms.

I am not quite familiar with the custom filtering behavior of the other vendor. In general, our RadGridView control exposes different filter options. You can check the following articles which describe the built-in filtering mechanism of the control.

• Basic Filtering
• Excel-like filtering
• Custom Filtering (programmatic filtering)

Another approach is to use different filtering controls which can be integrated with RadGridView.

• Data Filter control
• Filter View control

If none of these is an option for you, may I ask you to elaborate more on your filter requirement so that I can think of a suitable solution?

I am looking forward to your reply.

Regards,
Dinko | Tech Support Engineer
Progress Telerik

[Alexis]

yea basically is to create custom filter instead of using columns of datagrid having like picture a text input for example to search by name, a date input to filter by date range an so on

[Alexis]

im confused if i use filterview control, i dont need to create a custom sql query with a where clause for each view? Example text input, date range, salary etc? Or telerik does that automatically? Thats my concern as right now im using a webapp with react and i needed to create a big sql query with where clause for each of my text input date range salary etc

[Dinko | Tech Support Engineer]

Hello Alexis,

The FilterView control will generate a set of appropriate editors considering the respective field's data type. The control will create FilterDescriptor and apply it to the RadGridView control (in this case) which will filter its DataSource property. You don't need to create a query for each filter setting applied. You can get all the data and leave the FilterView to filter the data on the client side. 

I need to point out that the filter applied in the RadGridView will be on the client side. It will not create additional queries which update the data from the data source. You can create a query that gets all the data and applies it to the RadGridView. However, if you will need to reflect any changes applied in the RadGridView to the Database, you will need to manually update the respected Database row. You can check the Updating the Database with ADO.Net help article which demonstrates a possible way to reflect the changes to the database. 

I hope that my reply is helpful. If you have any other questions, feel free to contact us again.

Regards,
Dinko | Tech Support Engineer
Progress Telerik