Find duplicate Rows and highlights in WPF

Dinesh Santhalingam

9y4.1k

I have a datagrid view in my WPF Form.

I want to highlight the Row duplicates based on the LicenseName.

I bind a datatable to my Gridview as follows.

public DataTable table = new DataTable();
private void showdetailsbtn_Click(object sender, RoutedEventArgs e)
{
table.Columns.Add("Subcategoryname", typeof(string));
table.Columns.Add("Totallicense", typeof(int));
table.Columns.Add("Inuse", typeof(int));
// Here we add five DataRows.
table.Rows.Add("Indocin", 10,10);
table.Rows.Add("Indocin", 20, 10);
table.Rows.Add("Hydralazine", 5,4);
table.Rows.Add("Combivent", 11,2);
table.Rows.Add("Dilantin", 6,3);
licensegridview.DataContext = table;
}

Please help me to solve my problem .

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vishwash Roy9y ago
We can highlight the duplicate record by exposing few attached property.

In my given solution i have exposed three attached property
1. HighlightDuplicateRecord:- It is a boolean proerty, once it is set to true it will highlight the duplicate row with the given color.
2. DuplicateBy: It is a string property which takes property name by which it will find the duplicate record among ItemSource.(In case if you want to find duplicate record based on multiple properties, it can be given by comma seperated).
3. DuplicateRowBackground :- Background color of duplicate row.(Default is Transparent)

Xaml Code

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
xmlns:local="clr-namespace:WpfApplication4"
mc:Ignorable="d"
Title="MainWindow" Height="350" Width="525">

local:DataGridHelper.HighlightDuplicateRecord="True"
local:DataGridHelper.DuplicateBy="Subcategoryname,Totallicense" ItemsSource="{Binding Path=Table, UpdateSourceTrigger=PropertyChanged}" Grid.Row="1" x:Name="dataGrid">

Since it is a attached property,hence it can be used for any datagrid, any form of ItemsSource.

Hope, this will help you.
Nilesh Shah9y ago
This can be achieved using data trigger.

there are two things you need to do, one in .cs coding another in WPF XAML.

first using your logic in .cs file, identify if a row is duplicate or not, I leave it to you, for testing I am using fixed value. set a column value indicating row is duplicate (I used isDuplicate = 1)

then in WPF write a data trigeer to change row background if you find isDuplicate = 1
e.g.
<ListView.Resources>
                    <Style TargetType="{x:Type ListViewItem}">
                        <Style.Triggers>
                            <DataTrigger Binding="{Binding isDuplicate}" Value="1">
                                <Setter Property="Background" Value="Red" />
                            DataTrigger>
                        Style.Triggers>
                    Style>
                ListView.Resources>
I have attached complete project.