private void SetPivotGridData(DataTable dt, PivotGridControl pivotGrid) { XtraPivotGridHelper.DataViewTable dataTable = new XtraPivotGridHelper.DataViewTable(); foreach (DataColumn info in dt.Columns) { dataTable.AddColumn(info.ColumnName, info.ColumnName, info.DataType, PivotArea.RowArea, null, null); } pivotGrid.BeginUpdate(); pivotGrid.ClearPivotGridFields(); pivotGrid.CreatePivotGridFields(dataTable); pivotGrid.DataSource = dt; pivotGrid.EndUpdate(); if (dt.Rows.Count < 10000) { pivotGrid.BestFit(); } }
private void CreatePivotGridView(MainView subView, string itemName, DataTable dt) { DockPanel dockPanel = subView.DockManager.AddPanel(DockingStyle.Float); dockPanel.DockedAsTabbedDocument = true; dockPanel.Text = "Pivot"; dockPanel.Options.ShowCloseButton = false; PivotGridControl pivot = new PivotGridControl(); XtraPivotGridHelper.DataViewTable pivotData = new XtraPivotGridHelper.DataViewTable(); foreach (DataColumn dc in dt.Columns) { pivotData.AddColumn(dc.ColumnName, dc.ColumnName, dc.DataType, PivotArea.RowArea, null, null); } pivot.Dock = DockStyle.Fill; pivot.ClearPivotGridFields(); pivot.CreatePivotGridFields(pivotData); pivot.DataSource = dt; //pivot.BestFit(); dockPanel.Controls.Add(pivot); }