WPF Filterable Datagrid, multi language

A custom DataGrid control that inherits from the base DataGrid control class and override some methods to implement filters for each column, like Excel.

Information

Category: .NET / GUI
Watchers: 3
Star: 20
Fork: 3
Last update: Mar 8, 2021

Resource links

https://github.com/macgile/DataGridFilter

WPF Filterable DataGrid, multi language

A custom DataGrid control that inherits from the base DataGrid control class and override some methods to implement filters for each column, like Excel.

The translation of the displayed information is available in several languages.
Available languages: English, French, Russian, German, Italian, Chinese

The translations are from google translate, if you find any errors please let me know.

How to use

Include the FilterDataGrid folder in your project
Add FilterDataGrid.xaml to App.xaml as MergedDictionaries

    <Application.Resources>
        <ResourceDictionary>
            <ResourceDictionary.MergedDictionaries>
	    	<ResourceDictionary Source="FilterDataGrid/FilterDataGrid.xaml" />
		...

Add FilterDatagrid into your xaml :
- Namespace
```
<Window xmlns:control="clr-namespace:FilterDataGrid" ...
```
- 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
    - DateFormatString : date display format, default : "d"
    - 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" ...
```

Benchmark

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

0 Open More issues

Closed

Modification of the Popup style

Hi,

First of all: Thank you for your application.

I am currently creating a dark mode for my application. How can I change the colors of the backgrounds, borders and icons of the popup? If I see it correctly, the colors are hard-coded in the FilterDataGrid.xaml. Is it possible to overwrite these values, or can you make an adjustment in your application?

e. g. https://github.com/macgile/DataGridFilter/blob/d76f2566df69c4caf91b6148664fd6cd948ab01e/Shared/Themes/FilterDataGrid.xaml#L482-L483

Thank you

opened Dec 30, 2021 by Kruemelino 14

Closed

Data Grid Not Show Filters

I don't know where this problem comes from, but in some of my projects sometimes they don't appear the filter, any suggestions for me to fix this, any answer is appreciated.

opened Aug 18, 2021 by chuongmep 12

Closed

Nothing loading

Hi All.

I was using the nuget package in .NET Framework 4.7.2 and it was working fine. I then migrated the project to .NET 6 and then the gird no longer appeared. I'm not sure if it is because I am using .NET 6 or if I am doing something wrong, but any help would be much appreciated.

My current code: XAML:

xmlns:control="http://filterdatagrid.control.com/2021"
...
<control:FilterDataGrid x:Name="filterGrid" Grid.Column="1" Grid.Row="2" Grid.ColumnSpan="2"></control:FilterDataGrid>

XAML.CS:

...
filterGrid.DataContext = viewModel;
filterGrid.ItemsSource = viewModel.Contracts;
filterGrid.AutoGeneratedColumns += (_, _) =>
{
     filterGrid.Columns.RemoveAt(0);
     filterGrid.Columns.Move(10, 0);
     filterGrid.Columns.Move(13, 0);
     filterGrid.Columns[0].Header = "Contract (JobID)";
     filterGrid.Columns.RemoveAt(7);
     filterGrid.Columns.RemoveAt(13);
     filterGrid.Columns.RemoveAt(13);
     filterGrid.Columns.RemoveAt(13);
     filterGrid.Columns.RemoveAt(13);
};

Contracts is a IEnumerable<Contract> which is loaded before this code.

opened Jul 5, 2022 by mbaksh01 10

Closed

Row selection loses bright color when focus is lost

Hi, I'm using two DataGridFilters side by side and need to select several rows in both DataGridFilters to perform some actions. As soon as one of the DGF's losse focus the selection color changes from Highlight color to light gray (almost not visible).

Following solution seems to work for 'normal' datagrids, but not for DataGridFilter, can you help out how to accomplish this?

<DataGrid.Resources>

</DataGrid.Resources>

Kind regards.

opened Nov 30, 2021 by delosbomos 9

Closed

Update 1.2.6 can't display filterdatagrid

After I upgraded from 1.2.5 to 1.2.6, the DataGrid cannot be displayed，

opened Jun 16, 2022 by easyboot 7

Closed

How it works DateFormatString?

How can i use DateFormatString? I tried dd-MM-yy hh:mm:ss but not worked.

opened Sep 9, 2021 by BEDIRHANSAMSA 7

Open

Current nuget version (1.2.6) is invisible

But the same project works fine with latest source from github (commit ID) it says btw 1.2.7. so please refresh the nuget, so i can start using it :) thanks

opened Mar 15, 2023 by ToniMa1 0

Open

CanUserAddRows="False" disables filtering

If I set CanUserAddRows to false, the filter button is no longer available.

opened Mar 8, 2023 by kevbro02 1

Open

Incorrect Chinese sorting

After upgrading to 1.2.7, I found that the Chinese collation is different from 1.2.5. The new sorting method is incorrect

opened Feb 9, 2023 by easyboot 4

Open

Add filtering on nested objects

null

opened Jan 31, 2023 by RaceX58 1

Open

Filtering on children object property

Salut Gilles !

The filtering on a property of a children object doesn't seem to work. (See the last column)

    <filterdatagrid:FilterDataGrid
                Style="{DynamicResource MaterialDesignDataGrid}"
                ItemsSource="{Binding Documents, UpdateSourceTrigger=PropertyChanged}"
                SelectedItem="{Binding SelectedDocument}"
                FontSize="12"
                Grid.Row="1"
                MinHeight="150"
                MaxHeight="250"
                FilterLanguage="French"
                AutoGenerateColumns="False"
                CanUserAddRows="False"
                CanUserDeleteRows="False"
                SelectionMode="Single"
                SelectionUnit="FullRow">
                <filterdatagrid:FilterDataGrid.Columns>
                    <filterdatagrid:DataGridTemplateColumn
                        Width="50"
                        >
                        <filterdatagrid:DataGridTemplateColumn.CellTemplate>
                            <DataTemplate
                                >
                                <materialDesign:PackIcon
                                    Kind="{Binding DocumentIcon}"
                                    Foreground="{Binding LifeCycleVM.CurrentLifeCycle.Background}" />
                            </DataTemplate>
                        </filterdatagrid:DataGridTemplateColumn.CellTemplate>
                    </filterdatagrid:DataGridTemplateColumn>
                    <filterdatagrid:DataGridTextColumn
                        Header="Code"
                        Binding="{Binding Code}"
                        Width="150"
                        IsReadOnly="True"
                        IsColumnFiltered="True"
                        />
                    <filterdatagrid:DataGridTextColumn
                        Header="Révision"
                        Binding="{Binding Revision}"
                        Width="125"
                        IsReadOnly="True"                        
                        />
                    <filterdatagrid:DataGridTextColumn
                        Header="Version"
                        Binding="{Binding LatestDocumentVersion.FormattedVersion}"
                        Width="80"
                        IsReadOnly="True" />

                    <filterdatagrid:DataGridTextColumn
                        Header="Description"
                        Binding="{Binding Name}"
                        Width="250"
                        IsReadOnly="True"
                        IsColumnFiltered="True" />
                    <filterdatagrid:DataGridTextColumn
                        Header="Cycle de vie"
                        Binding="{Binding LifeCycleVM.CurrentLifeCycle.Description}"
                        Width="500"
                        IsReadOnly="True"
                        IsColumnFiltered="True" />
                </filterdatagrid:FilterDataGrid.Columns>
            </filterdatagrid:FilterDataGrid>

Is it a limitation or am I missing something?

Thanks in advance,

Sébastien

opened Jan 31, 2023 by RaceX58 5

Open

Feature request: Nested objects within the parent collection object filtering

Currently collections only show a filter by the toString() override that is within the collection. If the same collection is used twice in the datagrid that would make it useless. It would be nice to add nested collections in the filter by the value of the property within the collection at an unknown depth. I have provided a partial working solution. I haven't vetted out the actual filtering of the Items in the datagrid so this will not work with just the following code.

Code for FilterHelpers

public static Object GetPropValue(this Object obj, String name)
{
    foreach (String part in name.Split('.'))
    {
      if (obj == null) { return null; }

      Type type = obj.GetType();
      PropertyInfo info = type.GetProperty(part);
      if (info == null) { return null; }

            obj = info.GetValue(obj, null);
        }
        return obj;
 }

public static T GetPropValue<T>(this Object obj, String name) {
    Object retval = GetPropValue(obj, name);
    if (retval == null) { return default(T); }

    // throws InvalidCastException if types are incompatible
    return (T) retval;
}

Code for FilterDataGrid Line1270

.Select(item => Extensions.GetPropValue(item, fieldName))

opened Jan 10, 2023 by MrPlow254 4

1.2.7(Nov 13, 2022)

Net6.0 and Net7.0 support. Added Hugarian, Turkish, Japanese and Traditional Chinese languages. Removed pure Net Framework 4.7.2 version of FilterDataGrid. Mutualization in a shared project of the view model for the generation of test applications for the different versions of .Net. Removed ComponentResourceKey from FilterDataGrid style. Upgrading from Filterdategrid Net 4.7 to Net 4.8. Improved translation method.

Source code(tar.gz)
Source code(zip)

1.2.6.0(May 26, 2022)

Simplified and fixed logic errors, refactoring.

Source code(tar.gz)
Source code(zip)

1.2.5.2(Mar 18, 2022)

Add Polish language. The Time part of dates is supported. Fix and optimization.

Source code(tar.gz)
Source code(zip)

1.2.5.1(Mar 4, 2022)

Adding Exclude fields in AutoGenerateColumns mode

Source code(tar.gz)
Source code(zip)

1.2.5(Nov 28, 2021)

Port to .Net 5.0, .NET Core 3.1 Adding search operators "StartWith" and "Contains". Addition of the "ShowRowsCount" property which allows to display the row numbers. Ability to create an overall custom style based on the original FilterDataGrid style. Fixed various bugs.

Source code(tar.gz)
Source code(zip)

1.2.4(Sep 3, 2021)

Fixed filter disabled when updating or loading a new collection. Add Keydown Event on press enter in search box.

Source code(tar.gz)
Source code(zip)

.NET library for rendering mathematical formulae using the LaTeX typsetting style, for the WPF framework

WPF is a .NET Core UI framework for building Windows desktop applications.

The JHRS WPF framework is used to demonstrate how to use wpf and xamarin to build a development framework.

Filterable tree view monitor for Redux DevTools

Responsive, sortable, filterable and draggable layouts

Modern styles and controls for your WPF applications

Animated window borders for WPF.

A simple way to make your application written in WPF keep up with modern design trends.

The original .NET4 / WPF client.

Simple Grid Component written in React

Expandable, collapsible, filterable and single/multi selectable table view.

A very lightweight but powerful ViewModel-First MVVM framework for WPF for .NET Framework and .NET Core, inspired by Caliburn.Micro.

A framework that allows developers to cobble together a better UI for their own WPF applications with minimal effort.

A simple Calculator using Caliburn.Micro (WPF with MVVM)

Automatic WPF UI for single purpose tools and rapid prototyping

Google's Material Design in XAML & WPF, for C# & VB.Net.

MvvMChart is a simple, MVVM support and highly customizable WPF/UWP chart control

A modern WPF based Network Profiler for Unreal Engine.

A WPF control that provides a nice 2-dimentional virtual canvas using efficient QuadTree index

Chess.NET is a chess game with a clean architecture and design, written in C#/WPF.

Simple, flexible, interactive & powerful charts, maps and gauges for .Net, LiveCharts2 can now practically run everywhere WPF, WinForms, Xamarin, Avalonia, WinUI, UWP.

Share this repo

Related Repos

GUI

A WPF app for doing a budget

AWPFBudgetingApp A WPF app for doing a budget This app will allow users who want to setup a budget for their home or business on a desktop. Users will

GUI

The original .NET4 / WPF client.

CD Key Miner WPF This is the original CD Key Miner client for Windows, written in .NET4 and WPF. Installation Download the latest setup file from the

GUI

290

TUI (Text User Interface) (GUI Framework) implementation for Avalonia UI

TUI (Text User Interface) (GUI Framework) implementation for Avalonia UI Supports XAML, data bindings, animation, styling and the rest from Avalonia.

GUI

A rapid development framework for WPF.

Table of Contents 1.前言 2.框架组成 2.1 .Net核心扩展 2.2 模块化和依赖注入 2.3 日志系统 2.4 配置系统 2.5 数据库多连接支持 2.6 Dapper ORM 2.7 Local Storage 2.8 对象映射 2.9 WPF应用程序 2.10 多语言支

GUI

Switchie is a virtual destkop pager for Windows inspired by various Linux-based virtual de...

Switchie is a virtual destkop pager for Windows inspired by various Linux-based virtual desktop pagers

GUI

Editor for Microsoft RulesEngine - Blazor UI library intended for integration in Web or De...

Rules Engine Editor Editor for Microsoft Rules Engine - Blazor UI library intended for integration in Web or Desktop Overview Rules Engine Editor is a

GUI

1.6k

A Beautiful WPF Control UI

GUI

Allows administrators to easily specify a list of applications to remove, whether they are...

UninstallBloatware Using this module, you can easily specify a list of applications to remove, whether they are traditional Win32 applications or mode

GUI

UnityEvents drawer with collapsing, reordering and compact UX

GUI

295

Keeps your screen real-estate clean with refined, compact UX.

GUI

A WPF control that provides a nice 2-dimentional virtual canvas using efficient QuadTree i...

VirtualCanvas This project contains a WPF control that provides a nice 2-dimensional virtual canvas using an efficient QuadTree index and a demo that

GUI

4.9k

MudBlazor is an ambitious Material Design component framework for Blazor with an emphasis ...

Blazor Component Library based on Material design. The goal is to do more with Blazor, utilizing CSS and keeping Javascript to a bare minimum.

GUI

Animated window borders for WPF.

Snazzy WPF Animated Borders .NET 5 WPF app showing how to animate window borders. Watch the YouTube video or try the demo app on the releases page. Ho

GUI

423

A .NET Framework based GUI Proxy For Windows

A Clash GUI Proxy For Windows Based On .NET Framework 4.6.1

GUI

WPF Filterable Datagrid, multi language

A custom DataGrid control that inherits from the base DataGrid control class and override some methods to implement filters for each column, like Excel.