彩票走势图

数据筛选是我们常用的功能，本文通过一个具体的事例为大家展示DevExpress 是如何实现对特定字段进行数据筛选的。

下面的事例，目的是筛选出Country字段中含有 Brazil 或USA的数据，代码如下：

C#

using DevExpress.XtraPivotGrid;

PivotGridField field = pivotGridControl1.Fields["Country"];
// Lock the control to prevent excessive updates when multiple properties are modified.
pivotGridControl1.BeginUpdate(); 
try {
   // Clear the filter value collection and add two items to it.
   field.FilterValues.Clear();
   field.FilterValues.Add("Brazil");
   field.FilterValues.Add("USA");
   // Specify that the control should only display the records 
   // which contain the specified values in the Country field.
   field.FilterValues.FilterType = DevExpress.Data.PivotGrid.PivotFilterType.Included;
}
finally {
   // Unlock the control.
   pivotGridControl1.EndUpdate();
}

VB

Imports DevExpress.XtraPivotGrid

Dim field As PivotGridField = PivotGridControl1.Fields("Country")
' Lock the control to prevent excessive updates when multiple properties are modified.
PivotGridControl1.BeginUpdate()
Try
   ' Clear the filter value collection and add two items to it.
   field.FilterValues.Clear()
   field.FilterValues.Add("Brazil")
   field.FilterValues.Add("USA")
   ' Specify that the control should only display the records 
   ' which contain the specified values in the Country field.
   field.FilterValues.FilterType = DevExpress.Data.PivotGrid.PivotFilterType.Included
Finally
   ' Unlock the control.
   PivotGridControl1.EndUpdate()
End Try

慧都学院2017全新DevExpress线下研修班火热报名中！