A DataGrid control that inherits from the base DataGrid control class and override some methods to implement filters
for each column like Excel, in automatic or custom generation.
Support for nested objects and filter persistence.
Translation of labels and formatting of dates in the following languages: Chinese(traditional and simplified), Dutch, English, French, German, Hungarian, Italian, Japanese, Polish, Russian, Spanish, Turkish.
The translations are from google translate, if you find any errors or want to add other languages, please let me know.
The Nuget package is available here.
To understand how the filter works, you can consult the article posted on CodeProject.
For operation closer to that of Excel, see the version available in the repository FilterDataGrid-Beta.
This version uses a new filtering method that is completely different from the current version or the one commonly used to filter data (as far as I know).
<Stylex:Key="FilterDatagridStyle" BasedOn="{StaticResource {ComponentResourceKey TypeInTargetAssembly=control:FilterDataGrid, ResourceId=FilterDataGridStyle}}" TargetType="{x:Type control:FilterDataGrid}">
</Style>There are two ways to install :
NuGet command : Install-Package FilterDataGrid
Or manually add FilterDataGrid.dll as reference in your project
Add Namespace :
xmlns:control="http://filterdatagrid.control.com/2021" or
xmlns:control="clr-namespace:FilterDataGrid;assembly=FilterDataGrid" - Control
<control:FilterDataGridFilterLanguage="English"DateFormatString="d"ShowStatusBar="True"ShowElapsedTime="False"ExcludeFields="lastname,age,manager" ...Properties
ShowStatusBar : displays the status bar, default : false
ShowElapsedTime : displays the elapsed time of filtering in status bar, default : false
ShowRowsCount : display the number of rows, default : false
- If the value passed to RowHeaderWidth is greater than the calculation of the width of the column, this is the one that is used.FilterLanguage : translation into available language, default : English
PersistentFilter : enable/disable filter persistence , default : false
See below the detail of this featureExcludeFields : comma separated fields to exclude from filter, only works in AutoGenerateColumns mode
DateFormatString : date display format, default : "d"
⚠️ Before version 1.2.5.2, you must set the "Time" part of the DateTime fields to zero, otherwise the filter doesn't work.
see the documentation "Standard date and time format strings"Custom TextColumn / CheckBoxColumn
If you add custom columns, you must set AutoGenerateColumns="False"
<control:FilterDataGrid.Columns> <control:DataGridTextColumnIsColumnFiltered="True" ... /> <control:DataGridCheckBoxColumnIsColumnFiltered="True" ... />
Custom TemplateColumn
⚠️ FieldName property of DataGridTemplateColumn is required<control:FilterDataGrid.Columns> <control:DataGridTemplateColumnIsColumnFiltered="True"FieldName="LastName" ... />
You can define a global style which overrides the default style of "FilterDataGrid"
⚠️ The ComponentResourceKey is obsolete from version 1.2.7BasedOn="{StaticResource {ComponentResourceKey TypeInTargetAssembly=control:FilterDataGrid, ResourceId=FilterDataGridStyle}}"
<Application.Resources>
<Stylex:Key="FilterDatagridStyle"TargetType="{x:Type control:FilterDataGrid}">
<SetterProperty="Margin"Value="10" />
<SetterProperty="RowHeaderWidth"Value="40" />
...
</Style>
</Application.Resources>
<!-- usage -->
<control:FilterDataGridStyle="{StaticResource FilterDatagridStyle}" ...Enabling the PersistentFilter property saves a json file in the application folder that contains the status of active filters, any modification of the filters is immediately saved until the closing of the application, it is this state of the filters which will be loaded during the new launch of the application.
The name of the json file is inferred from the name you give to your FilterDataGrid control.
<control:FilterDataGridx:Name="MyFilterDatagrid"If it is not provided, the type name of the source collection is used, for example for a generic list of type Employees, Employees will be used
// collection used as ItemsSourceList<Employees>Two methods (LoadPreset/SavePreset) are exposed to be able to manually manage loading and saving from the host application.
These methods are independent of the PersistentFilter property whatever its state.
// Load PresetMyFilterDatagrid.LoadPreset();// Save PresetMyFilterDatagrid.SavePreset();Be aware that the filters must remain consistent with your source collection, for example if you filter on a "True" Boolean field and when the application is launched your collection no longer contains the "True" value for this field, the filter application may cause unexpected results.
This is especially true for demo applications that use random data generation.
Intel Core i7, 2.93 GHz, 16 GB, Windows 10, 64 bits.
Tested on the "Last name" column of the demo application using a random distinct name generator, between 5 and 8 letters in length.
The elapsed time decreases based on the number of columns and filtered items.
| Number of rows | Opening of the PopUp | Applying the filter | Total (PopUp + Filter) |
|---|---|---|---|
| 10 000 | < 1 second | < 1 second | < 1 second |
| 100 000 | < 1 second | < 1 second | < 1 second |
| 500 000 | ± 1.5 second | ± 1 second | ± 2.5 seconds |
| 1 000 000 | ± 3 seconds | ± 1.5 seconds | ± 4.5 seconds |
