本文通過一個具體事例來給大家演示，用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";
}