Multiple value filtering

[Serdar]

Hi,

How can i filter multiple value on filter column programmability ?

my column type gridnumericcolumn

thanks for helps

[Vijayarasan Sivanandham]

Hi Serdar,

Your requirement can be achieved by applying multiple FilterPredicates for a column in SfDataGrid. Please refer the below code snippet,

 

sfDataGrid.Columns.Add(New GridNumericColumn() With { 

                                                                .MappingName = "OrderID", 

                                                                .HeaderText = "Order ID" 

                                                }) 

 

'Filter the OrderID column with values "1001" or "1003" 

sfDataGrid.Columns("OrderID").FilterPredicates.Add(New FilterPredicate() With 

 { 

                                .FilterType = FilterType.Equals, 

                                .FilterValue = 1001, 

                                .PredicateType = PredicateType.Or 

}) 

sfDataGrid.Columns("OrderID").FilterPredicates.Add(New FilterPredicate() With  

{ 

                                .FilterType = FilterType.Equals, 

                                .FilterValue = 1003, 

                                .PredicateType = PredicateType.Or 

}) 

Sample Link: https://www.syncfusion.com/downloads/support/forum/172370/ze/SfDataGridDemo-1165396540

For more information, please refer the below user guide documentation link, 

UG Link: https://help.syncfusion.com/windowsforms/datagrid/filtering?cs-save-lang=1&cs-lang=vb#adding-multiple-filterpredicates-for-a-column

https://help.syncfusion.com/windowsforms/datagrid/filtering?cs-save-lang=1&cs-lang=vb#programmatic-filtering

Please let us know if you have any concerns in this. 

Regards, 

Vijayarasan S 

[Serdar]

Hi  Vijayarasan,

Your code is work

thanks for help

[Vijayarasan Sivanandham]

Hi Serdar,

We are glad to know that the reported problem has been resolved at your end. Please let us know if you have any further queries on this. We are happy to help you😊.

Regards,
Vijayarasan S