Gets or sets a value indicating whether distinct values are to be calculated for the property or not.
'Declaration
Public Property CalculateDistinctValues As Boolean
'Usage
Dim instance As DataGridItemPropertyBase
Dim value As Boolean
instance.CalculateDistinctValues = value
value = instance.CalculateDistinctValues
public bool CalculateDistinctValues {get; set;}
Property Value
true if distinct values are to be calculated;
false otherwise. By default (if automatic filtering is enabled),
true.
All examples in this topic assume that the grid is bound to the Orders table of the Northwind database, unless stated otherwise.
The following example demonstrates how to enable automatic filtering, disabling it for the columns that will not support it and filtering the distinct values of the ShipCity column.
<Grid>
<Grid.Resources>
<xcdg:DataGridCollectionViewSource x:Key="cvs_orders"
Source="{Binding Source={x:Static Application.Current},
Path=Orders}"
AutoFilterMode="And"
DistinctValuesConstraint="Filtered"
AutoCreateItemProperties="False">
<xcdg:DataGridCollectionViewSource.ItemProperties>
<xcdg:DataGridItemProperty Name="ShipCountry"
Title="Country"/>
<xcdg:DataGridItemProperty Name="ShipCity"
Title="City"/>
<xcdg:DataGridItemProperty Name="ShipAddress"
Title="Address"/>
<xcdg:DataGridItemProperty Name="ShipPostalCode"
Title="Postal Code"/>
<xcdg:DataGridItemProperty Name="ShipName"
Title="Name"
CalculateDistinctValues="False"/>
<xcdg:DataGridItemProperty Name="OrderDate"
Title="Order Date"
CalculateDistinctValues="False"/>
<xcdg:DataGridItemProperty Name="Freight"
CalculateDistinctValues="False"/>
</xcdg:DataGridCollectionViewSource.ItemProperties>
</xcdg:DataGridCollectionViewSource>
</Grid.Resources>
<xcdg:DataGridControl x:Name="OrdersGrid"
ItemsSource="{Binding Source={StaticResource cvs_orders}}"/>
</Grid>
Target Platforms: Windows 11, Windows, 10, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2