彩票走势图

本文通过一个具体事例来给大家演示，用DevExpress XtraGrid网格控件如何实现数据的自定义分组。

本例中，将产品数据分为A-E, F-S和 T-Z这三组:

代码如下：

VB

Protected Sub PivotGridControl_CustomGroupInterval(ByVal sender As Object, _
ByVal e As PivotCustomGroupIntervalEventArgs) _
Handles pivotGridControl.CustomGroupInterval
If e.Field.Caption <> "Product Group" Then Return
If Convert.ToChar(e.Value.ToString().Chars(0)) < "F"c Then
e.GroupValue = "A-E"
Return
End If
If Convert.ToChar(e.Value.ToString().Chars(0)) > "E"c _
AndAlso Convert.ToChar(e.Value.ToString().Chars(0)) < "T"c Then
e.GroupValue = "F-S"
Return
End If
If Convert.ToChar(e.Value.ToString().Chars(0)) > "S"c Then
e.GroupValue = "T-Z"
End If
End Sub

C#

protected void PivotGridControl_CustomGroupInterval(object sender,
PivotCustomGroupIntervalEventArgs e) {
if (e.Field.Caption != "Product Group") return;

if (Convert.ToChar(e.Value.ToString()[0]) < 'F') {
e.GroupValue = "A-E";
return;
}

if (Convert.ToChar(e.Value.ToString()[0]) > 'E' &&
Convert.ToChar(e.Value.ToString()[0]) < 'T') {
e.GroupValue = "F-S";
return;
}

if (Convert.ToChar(e.Value.ToString()[0]) > 'S')
e.GroupValue = "T-Z";
}