How to load NumberFilters in AdvanceFilters using dynamic collection in WPF DataGrid (SfDataGrid)?

4 mins read

The Text Filters will be loaded automatically in AdvancedFilter when we bind the dynamic collection in WPF DataGrid (SfDataGrid). If you want to load Number Filters or Date Filters based on column values, you have to set the underlying property type in GridColumn.ColumnMemberType property.

//Set ColumnMemberType  
this.sfDataGrid.Columns[2].ColumnMemberType = typeof(double?);

XAML

<syncfusion:GridNumericColumn  MappingName="CustomerID"
                                              ColumnMemberType="{x:Type system:Double}"
                                              AllowNullValue="True"
                                              AllowFiltering="True"

View sample in GitHub.

Did you find this information helpful?

Yes

Comments (0)

How to load NumberFilters in AdvanceFilters using dynamic collection in WPF DataGrid (SfDataGrid)?

Access denied