how use comparison operators in filter row

[Serdar]

hi,

how use comparison operators in filter row?

for  gridnumericcolumn type like this: ">100" , "!0"

for gridtextcolumn type like this : "!Serdar" , "vb|vba|c", “120.0001:320.9999,"S:"

for other column type ...

thanks for your help

[Vijayarasan Sivanandham]

Hi Serdar,

We are little unclear with your update. We suspect that your requirement is to change the initial filter row condition in SfDataGrid. This can be achieved by setting the FilterRowCondition in GridColumn. Please refer the below code snippet,

 

this.sfDataGrid1.AutoGenerateColumns = false; 

this.sfDataGrid1.FilterRowPosition = RowPosition.Top; 

this.sfDataGrid1.Columns.Add(new GridNumericColumn() { MappingName = "OrderID", HeaderText = "Order ID", FilterRowCondition = FilterRowCondition.GreaterThan }); 

this.sfDataGrid1.Columns.Add(new GridTextColumn() { MappingName = "CustomerID", HeaderText = "Customer ID", FilterRowCondition = FilterRowCondition.NotEquals }); 

this.sfDataGrid1.Columns.Add(new GridTextColumn() { MappingName = "CustomerName", HeaderText = "Customer Name", FilterRowCondition = FilterRowCondition.Equals }); 

this.sfDataGrid1.Columns.Add(new GridTextColumn() { MappingName = "Country", HeaderText = "Country", FilterRowCondition = FilterRowCondition.Contains }); 

this.sfDataGrid1.Columns.Add(new GridTextColumn() { MappingName = "ShipCity", HeaderText = "Ship City", FilterRowCondition = FilterRowCondition.DoesNotContain });            

sfDataGrid1.DataSource = table; 

Sample Link: https://www.syncfusion.com/downloads/support/forum/172174/ze/SfDataGridDemo1598023726

For more information related to FilterRow Options, please refer the below user guide documentation link, 

UG Link: https://help.syncfusion.com/windowsforms/datagrid/filterrow#filterrow-options

https://help.syncfusion.com/windowsforms/datagrid/filterrow#customizing-filterrow-cellrenderer

https://help.syncfusion.com/windowsforms/datagrid/filterrow#built-in-filterrow-editor-types

If we misunderstood your requirement, please provide more information regarding the requirement. This would help us to proceed further. 

Regards, 

Vijayarasan S