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.

Translation of labels and formatting of dates in the following languages: English, French, Russian, German, Italian, Chinese, Dutch.

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.

• There are two ways to install :

  • NuGet command : Install-Package FilterDataGrid
  • Or manually add FilterDataGrid.dll as reference in your project

• Add FilterDatagrid into your xaml :

  • Namespace

    <Window xmlns:control="http://filterdatagrid.control.com/2021" ...

  • Control

    <control:FilterDataGrid 
     FilterLanguage="English" DateFormatString="d" ShowStatusBar="True" ShowElapsedTime="False" ...

    • 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
      • DateFormatString : date display format, default : "d"

      You must delete the time or set it to zero in the DateTime field, otherwise the filter does not work.
      see the documentation "Standard date and time format strings"

      • FilterLanguage : translation into available language, default : English

  If you add custom columns, you must set AutoGenerateColumns="False"

  • Custom TextColumn

    <control:FilterDataGrid.Columns>   
        <control:DataGridTextColumn IsColumnFiltered="True" ...

  • Custom TemplateColumn

    FieldName property of DataGridTemplateColumn is required

    <control:FilterDataGrid.Columns>   
        <control:DataGridTemplateColumn IsColumnFiltered="True"
    	                            FieldName="LastName" ...

You can define a global style which overrides the default style of "FilterDataGrid"

<Style
            x:Key="FilterDatagridStyle"
            BasedOn="{StaticResource {ComponentResourceKey TypeInTargetAssembly=control:FilterDataGrid,
                                                           ResourceId=FilterDataGridStyle}}"
            TargetType="{x:Type control:FilterDataGrid}">
            <Setter Property="Margin" Value="10" />
            <Setter Property="RowHeaderWidth" Value="40" />
	    ...
</Style>

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.