https://download.csdn.net/blog/column/9993043/120721622
①将创建的GridControl下的GirdView1转化为BandGridView类型；
②创建需要展示的列（指定列的名称【Name】、描述【caption】、数据字段名称【FieldName】）
③绑定列实现复合表头。
注意：如果复合表头有多行，则需要设置新增Band的Row Count，然后设置【Band properties下的AutoFillDown=false】
代码例子https://www.shuzhiduo.com/A/lk5aG060z1/
1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Windows.Forms;
5 using DevExpress.XtraGrid.Columns;
6 using DevExpress.XtraGrid.Views.Base;
7 using DevExpress.XtraGrid.Views.BandedGrid;
8 using DevExpress.XtraEditors.Repository;
9
10 namespace XtraGridDemo1
11 {
12 public partial class Form1 : DevExpress.XtraEditors.XtraForm
13 {
14 public Form1()
15 {
16 InitializeComponent();
17
18 //首先拖到窗体上一个GridControl，在表格上点击“Click here to change view”链接，在弹出菜单中选择“convert to”-->“AdvBandedGridView”。
19
20 InitGrid();
21 }
22
23 ///初始化表格
24 private void InitGrid()
25 {
26
27 // advBandedGridView1是表格上的默认视图，注意这里声明的是：BandedGridView
28 BandedGridView view = advBandedGridView1 as BandedGridView;
29
30 view.BeginUpdate(); //开始视图的编辑，防止触发其他事件
31 view.BeginDataUpdate(); //开始数据的编辑
32
33 view.Bands.Clear();
34
35 //修改附加选项
36 view.OptionsView.ShowColumnHeaders = false; //因为有Band列了，所以把ColumnHeader隐藏
37 view.OptionsView.ShowGroupPanel = false; //如果没必要分组，就把它去掉
38 view.OptionsView.EnableAppearanceEvenRow = false; //是否启用偶数行外观
39 view.OptionsView.EnableAppearanceOddRow = true; //是否启用奇数行外观
40 view.OptionsView.ShowFilterPanelMode = ShowFilterPanelMode.Never; //是否显示过滤面板
41 view.OptionsCustomization.AllowColumnMoving = false; //是否允许移动列
42 view.OptionsCustomization.AllowColumnResizing = false; //是否允许调整列宽
43 view.OptionsCustomization.AllowGroup = false; //是否允许分组
44 view.OptionsCustomization.AllowFilter = false; //是否允许过滤
45 view.OptionsCustomization.AllowSort = true; //是否允许排序
46 view.OptionsSelection.EnableAppearanceFocusedCell = true; //???
47 view.OptionsBehavior.Editable = true; //是否允许用户编辑单元格
48
49 //添加列标题
50 GridBand bandID = view.Bands.AddBand("ID");
51 bandID.Visible = false; //隐藏ID列
52 GridBand bandName = view.Bands.AddBand("姓名");
53 GridBand bandSex = view.Bands.AddBand("性别");
54 GridBand bandBirth = view.Bands.AddBand("出生日期");
55 GridBand bandScore = view.Bands.AddBand("分数");
56 GridBand bandMath = bandScore.Children.AddBand("数学");
57 GridBand bandChinese = bandScore.Children.AddBand("语文");
58 GridBand bandEnglish = bandScore.Children.AddBand("英语");
59 GridBand bandSubTotal = bandScore.Children.AddBand("小计");
60 GridBand bandRemark = view.Bands.AddBand("备注");
61
62 //列标题对齐方式
63 bandName.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
64 bandSex.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
65 bandBirth.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
66 bandScore.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
67 bandMath.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
68 bandChinese.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
69 bandEnglish.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
70 bandSubTotal.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
71 bandRemark.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
72
73 //模拟几个数据
74 List<Record> listDataSource = new List<Record>();
75 listDataSource.Add(new Record(1, "张三","男",Convert.ToDateTime("1989-5-6") ,115.5f,101,96,""));
76 listDataSource.Add(new Record(2, "李四", "女", Convert.ToDateTime("1987-12-23"), 92, 85, 87, ""));
77 listDataSource.Add(new Record(3, "王五", "女", Convert.ToDateTime("1990-2-11"), 88, 69, 41.5f, ""));
78 listDataSource.Add(new Record(4, "赵六", "男", Convert.ToDateTime("1988-9-1"), 119, 108, 110, "备注行"));
79 //绑定数据源并显示
80 gridControl1.DataSource = listDataSource;
81 gridControl1.MainView.PopulateColumns();
82
83 //[小计]这一列因为没绑定数据源，所以需要手动添加
84 //(有点复杂，慢慢看吧)
85 string[] fieldNames = new string[] { "SubTotal" };
86 GridColumn column; //声明单列
87 column = view.Columns.AddField(fieldNames[0]); //添加一个数据字段
88 column.VisibleIndex = view.Columns.Count -1; //设置该列在编辑视图时的显示位置(倒数第二列)
89 column.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
90 column.OptionsColumn.AllowEdit = false; //此列不可编辑
91 column.Visible = true;
92 view.Columns.Add(column); //视图中添加一列
93
94 //绑定事件，当[分数]改变时[小计]也跟着变
95 //(好像只有在绑定事件里才能改变该单元格数值，直接修改无效)
96 view.CustomUnboundColumnData += new
97 DevExpress.XtraGrid.Views.Base.CustomColumnDataEventHandler(advBandedGridView1_CustomUnboundColumnData);
98
99 //[性别]列绑定ComboBox
100 RepositoryItemComboBox riCombo = new RepositoryItemComboBox();
101 riCombo.Items.AddRange(new string[] {"男", "女"});
102 gridControl1.RepositoryItems.Add(riCombo);
103 view.Columns["Sex"].ColumnEdit = riCombo;
104
105 //[出生年月]列绑定Date
106 RepositoryItemDateEdit riDate = new RepositoryItemDateEdit();
107 gridControl1.RepositoryItems.Add(riDate);
108 view.Columns["Birth"].ColumnEdit = riDate;
109
110 //[分数]列绑定SpinEdit
111 RepositoryItemSpinEdit riSpin = new RepositoryItemSpinEdit();
112 gridControl1.RepositoryItems.Add(riSpin);
113 view.Columns["Math"].ColumnEdit = riSpin;
114 view.Columns["Chinese"].ColumnEdit = riSpin;
115 view.Columns["English"].ColumnEdit = riSpin;
116
117 //[备注]列绑定MemoExEdit
118 RepositoryItemMemoExEdit riMemoEx = new RepositoryItemMemoExEdit();
119 gridControl1.RepositoryItems.Add(riMemoEx);
120 view.Columns["Remark"].ColumnEdit = riMemoEx;
121
122 //小计列添加汇总
123 view.OptionsView.ShowFooter = true; //显示表格页脚
124 view.Columns["SubTotal"].SummaryItem.FieldName = "SubTotal";
125 view.Columns["SubTotal"].SummaryItem.DisplayFormat = "{0:f2}";
126 view.Columns["SubTotal"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Average;
127
128 //将标题列和数据列对应
129 view.Columns["ID"].OwnerBand = bandID;
130 view.Columns["Name"].OwnerBand = bandName;
131 view.Columns["Sex"].OwnerBand = bandSex;
132 view.Columns["Birth"].OwnerBand = bandBirth;
133 view.Columns["Math"].OwnerBand = bandMath;
134 view.Columns["Chinese"].OwnerBand = bandChinese;
135 view.Columns["English"].OwnerBand = bandEnglish;
136 view.Columns["SubTotal"].OwnerBand = bandSubTotal;
137 view.Columns["Remark"].OwnerBand = bandRemark;
138
139 view.EndDataUpdate();//结束数据的编辑
140 view.EndUpdate(); //结束视图的编辑
141
142 }
143
144 // 计算小计
145 private float calcSubTotal(float math, float chinese, float english)
146 {
147 return math + chinese + english;
148 }
149
150 private void advBandedGridView1_CustomUnboundColumnData(object sender, CustomColumnDataEventArgs e)
151 {
152 ColumnView colView = sender as ColumnView;
153 if (e.Column.FieldName == "SubTotal" && e.IsGetData) e.Value = calcSubTotal(
154 Convert.ToSingle(colView.GetRowCellValue(e.RowHandle, colView.Columns["Math"])),
155 Convert.ToSingle(colView.GetRowCellValue(e.RowHandle, colView.Columns["Chinese"])),
156 Convert.ToSingle(colView.GetRowCellValue(e.RowHandle, colView.Columns["English"])));
157 }
158
159 #region 运行时绑定到实现Ilist接口的数据源
160
161 public class Record
162 {
163 int id;
164 DateTime birth;
165 string name, sex, remark;
166 float math, chinese, english;
167 public Record(int id, string name, string sex, DateTime birth, float math, float chinese, float english, string remark)
168 {
169 this.id = id;
170 this.name = name;
171 this.sex = sex;
172 this.birth = birth;
173 this.math = math;
174 this.chinese = chinese;
175 this.english = english;
176 this.remark = remark;
177 }
178 public int ID { get { return id; } }
179 public string Name
180 {
181 get { return name; }
182 set { name = value; }
183 }
184 public string Sex
185 {
186 get { return sex; }
187 set { sex = value; }
188 }
189 public DateTime Birth
190 {
191 get { return birth; }
192 set { birth = value; }
193 }
194 public float Math
195 {
196 get { return math; }
197 set { math = value; }
198 }
199 public float Chinese
200 {
201 get { return chinese; }
202 set { chinese = value; }
203 }
204 public float English
205 {
206 get { return english; }
207 set { english = value; }
208 }
209 public string Remark
210 {
211 get { return remark; }
212 set { remark = value; }
213 }
214
215 }
216
217 #endregion
218
219 }
220 }
标签：C#,DevExpress,float,表头,new,public,Columns,view From： https://www.cnblogs.com/luyj00436/p/18455733