The following example demonstrates how to create DataFilter objects, and apply their conditions to a series at runtime. For more information, refer to Filtering Data.
For this example to work correctly, a chart should contain at least one series, which is bound to the "Categories" data table in the Northwind Traders database (nwind.mdb file shipped with the XtraCharts demo). Please refer to the following tutorial to see how to bind a series to data: How to: Bind Individual Chart Series to Data (Runtime Sample).
The code below creates and applies the following filter to series data: "CategoryID = 1 or CategoryID = 4 or CategoryID = 7"
| C# |
using DevExpress.XtraCharts;
DataFilter dataFilter1 = new DataFilter("CategoryID", "System.Int32", DataFilterCondition.Equal, 1);
DataFilter dataFilter2 = new DataFilter("CategoryID", "System.Int32", DataFilterCondition.Equal, 4);
DataFilter dataFilter3 = new DataFilter("CategoryID", "System.Int32", DataFilterCondition.Equal, 7);
Series series1 = chartControl1.Series[0];
series1.DataFiltersConjunctionMode = ConjunctionTypes.Or;
series1.DataFilters.Clear();
series1.DataFilters.AddRange(new DataFilter[] {dataFilter1, dataFilter2, dataFilter3});
|
| VB |
Imports DevExpress.XtraCharts
Dim dataFilter1 As New DataFilter("CategoryID", "System.Int32", DataFilterCondition.Equal, 1)
Dim dataFilter2 As New DataFilter("CategoryID", "System.Int32", DataFilterCondition.Equal, 4)
Dim dataFilter3 As New DataFilter("CategoryID", "System.Int32", DataFilterCondition.Equal, 7)
Dim series1 As Series = chartControl1.Series(0)
series1.DataFiltersConjunctionMode = ConjunctionTypes.Or
series1.DataFilters.Clear()
series1.DataFilters.AddRange(New DataFilter() {dataFilter1, dataFilter2, dataFilter3})
|