彩票走势图

示例图如下:

我们点击第一列1994年下面的第三行单元格数据，就会显示出与这个单元格相关联的数据库数据：

代码如下：

C#

using DevExpress.XtraPivotGrid;

private void pivotGridControl1_CellDoubleClick(object sender, PivotCellEventArgs e) {
   // Create a new form.
   Form form = new Form();
   form.Text = "Records";
   // Place a DataGrid control on the form.
   DataGrid grid = new DataGrid();
   grid.Parent = form;
   grid.Dock = DockStyle.Fill;
   // Get the recrd set associated with the current cell and bind it to the grid.
   grid.DataSource = e.CreateDrillDownDataSource();
   form.Bounds = new Rectangle(100, 100, 500, 400);
   // Display the form.
   form.ShowDialog();
   form.Dispose();
}

VB

Imports DevExpress.XtraPivotGrid

Private Sub pivotGridControl1_CellDoubleClick(ByVal sender As Object, _
  ByVal e As PivotCellEventArgs) Handles pivotGridControl1.CellDoubleClick
   ' Create a new form.
   Dim form As Form = New Form
   form.Text = "Records"
   ' Place a DataGrid control on the form.
   Dim grid As DataGrid = New DataGrid
   grid.Parent = form
   grid.Dock = DockStyle.Fill
   ' Get the recrd set associated with the current cell and bind it to the grid.
   grid.DataSource = e.CreateDrillDownDataSource()
   form.Bounds = New Rectangle(100, 100, 500, 400)
   ' Display the form.
   form.ShowDialog()
   form.Dispose()
End Sub