动态添加XtraPrivotGrid/XtraGrid
//xtraPrivot var colEmpName = new PivotGridField { Area = PivotArea.FilterArea, AreaIndex = num, FieldName = item.Caption, Name = "col" + item.Caption, Caption = item.Caption, /这里设置数据区的统计类型为统计数量 }; num++; this.pivotGridControl1.Fields.AddRange(new[] { colEmpName }); //PrivotGridControl赋值 pivotGridControl1.DataSource = dt;
//XtraGrid GridView gridView = new GridView(); gridView.Columns.ColumnByFieldName(item.Caption); //gridControl 赋值 gridControl1.DataSource = dt;
//布局储存、读取
var gridLayoutFileName= Path.Combine(AppDomain.CurrentDomain.BaseDirectory)//绝对地址 //保存布局 pivotGridControl1.SaveLayoutToXml(gridLayoutFileName, DevExpress.Utils.OptionsLayoutBase.FullLayout); //读取布局 pivotGridControl1.RestoreLayoutFromXml(gridLayoutFileName, DevExpress.Utils.OptionsLayoutBase.FullLayout);