Devexpress使用之：GridControl控件

using System;using System.Collections.Generic;using System.ComponentModel;using System.Windows.Forms;using DevExpress.XtraGrid.Columns;using DevExpress.XtraGrid.Views.Base;using DevExpress.XtraGrid.Views.BandedGrid;using DevExpress.XtraEditors.Repository;namespace XtraGridDemo1{public partial class Form1 : DevExpress.XtraEditors.XtraForm{public Form1(){InitializeComponent();//首先拖到窗体上一个GridControl，在表格上点击“Click here to change view”链接，在弹出菜单中选择“convert to”-->“AdvBandedGridView”。InitGrid();}///初始化表格private void InitGrid(){// advBandedGridView1是表格上的默认视图，注意这里声明的是：BandedGridViewBandedGridView view = advBandedGridView1 as BandedGridView;view.BeginUpdate(); //开始视图的编辑，防止触发其他事件view.BeginDataUpdate(); //开始数据的编辑view.Bands.Clear();//修改附加选项view.OptionsView.ShowColumnHeaders = false;                         //因为有Band列了，所以把ColumnHeader隐藏view.OptionsView.ShowGroupPanel = false;                            //如果没必要分组，就把它去掉view.OptionsView.EnableAppearanceEvenRow = false;                   //是否启用偶数行外观view.OptionsView.EnableAppearanceOddRow = true;                     //是否启用奇数行外观view.OptionsView.ShowFilterPanelMode = ShowFilterPanelMode.Never;   //是否显示过滤面板view.OptionsCustomization.AllowColumnMoving = false;                //是否允许移动列view.OptionsCustomization.AllowColumnResizing = false;              //是否允许调整列宽view.OptionsCustomization.AllowGroup = false;                       //是否允许分组view.OptionsCustomization.AllowFilter = false;                      //是否允许过滤view.OptionsCustomization.AllowSort = true;                         //是否允许排序view.OptionsSelection.EnableAppearanceFocusedCell = true;           //???view.OptionsBehavior.Editable = true;                               //是否允许用户编辑单元格//添加列标题GridBand bandID = view.Bands.AddBand("ID");bandID.Visible = false; //隐藏ID列GridBand bandName = view.Bands.AddBand("姓名");GridBand bandSex = view.Bands.AddBand("性别");GridBand bandBirth = view.Bands.AddBand("出生日期");GridBand bandScore = view.Bands.AddBand("分数");GridBand bandMath = bandScore.Children.AddBand("数学");GridBand bandChinese = bandScore.Children.AddBand("语文");GridBand bandEnglish = bandScore.Children.AddBand("英语");GridBand bandSubTotal = bandScore.Children.AddBand("小计");GridBand bandRemark = view.Bands.AddBand("备注");//列标题对齐方式bandName.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;bandSex.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;bandBirth.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;bandScore.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;bandMath.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;bandChinese.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;bandEnglish.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;bandSubTotal.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;bandRemark.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;//模拟几个数据List<Record> listDataSource = new List<Record>();listDataSource.Add(new Record(1, "张三","男",Convert.ToDateTime("1989-5-6") ,115.5f,101,96,""));listDataSource.Add(new Record(2, "李四", "女", Convert.ToDateTime("1987-12-23"), 92, 85, 87, ""));listDataSource.Add(new Record(3, "王五", "女", Convert.ToDateTime("1990-2-11"), 88, 69, 41.5f, ""));listDataSource.Add(new Record(4, "赵六", "男", Convert.ToDateTime("1988-9-1"), 119, 108, 110, "备注行"));//绑定数据源并显示gridControl1.DataSource = listDataSource;gridControl1.MainView.PopulateColumns();//[小计]这一列因为没绑定数据源，所以需要手动添加//(有点复杂，慢慢看吧)string[] fieldNames = new string[] { "SubTotal" };GridColumn column;   //声明单列column = view.Columns.AddField(fieldNames[0]);  //添加一个数据字段column.VisibleIndex = view.Columns.Count -1;  //设置该列在编辑视图时的显示位置(倒数第二列)  column.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;column.OptionsColumn.AllowEdit = false;     //此列不可编辑column.Visible = true;view.Columns.Add(column);   //视图中添加一列//绑定事件，当[分数]改变时[小计]也跟着变//(好像只有在绑定事件里才能改变该单元格数值，直接修改无效)view.CustomUnboundColumnData += newDevExpress.XtraGrid.Views.Base.CustomColumnDataEventHandler(advBandedGridView1_CustomUnboundColumnData);//[性别]列绑定ComboBoxRepositoryItemComboBox riCombo = new RepositoryItemComboBox();riCombo.Items.AddRange(new string[] {"男", "女"});gridControl1.RepositoryItems.Add(riCombo);view.Columns["Sex"].ColumnEdit = riCombo;//[出生年月]列绑定DateRepositoryItemDateEdit riDate = new RepositoryItemDateEdit();gridControl1.RepositoryItems.Add(riDate);view.Columns["Birth"].ColumnEdit = riDate;//[分数]列绑定SpinEditRepositoryItemSpinEdit riSpin = new RepositoryItemSpinEdit();gridControl1.RepositoryItems.Add(riSpin);view.Columns["Math"].ColumnEdit = riSpin;view.Columns["Chinese"].ColumnEdit = riSpin;view.Columns["English"].ColumnEdit = riSpin;//[备注]列绑定MemoExEditRepositoryItemMemoExEdit riMemoEx = new RepositoryItemMemoExEdit();gridControl1.RepositoryItems.Add(riMemoEx);view.Columns["Remark"].ColumnEdit = riMemoEx;//小计列添加汇总view.OptionsView.ShowFooter = true;     //显示表格页脚view.Columns["SubTotal"].SummaryItem.FieldName = "SubTotal";view.Columns["SubTotal"].SummaryItem.DisplayFormat = "{0:f2}";view.Columns["SubTotal"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Average;//将标题列和数据列对应view.Columns["ID"].OwnerBand = bandID;view.Columns["Name"].OwnerBand = bandName;view.Columns["Sex"].OwnerBand = bandSex;view.Columns["Birth"].OwnerBand = bandBirth;view.Columns["Math"].OwnerBand = bandMath;view.Columns["Chinese"].OwnerBand = bandChinese;view.Columns["English"].OwnerBand = bandEnglish;view.Columns["SubTotal"].OwnerBand = bandSubTotal;view.Columns["Remark"].OwnerBand = bandRemark;view.EndDataUpdate();//结束数据的编辑view.EndUpdate();   //结束视图的编辑}// 计算小计private float calcSubTotal(float math, float chinese, float english){return math + chinese + english;}private void advBandedGridView1_CustomUnboundColumnData(object sender, CustomColumnDataEventArgs e){ColumnView colView = sender as ColumnView;if (e.Column.FieldName == "SubTotal" && e.IsGetData) e.Value = calcSubTotal(Convert.ToSingle(colView.GetRowCellValue(e.RowHandle, colView.Columns["Math"])),Convert.ToSingle(colView.GetRowCellValue(e.RowHandle, colView.Columns["Chinese"])),Convert.ToSingle(colView.GetRowCellValue(e.RowHandle, colView.Columns["English"])));}#region 运行时绑定到实现Ilist接口的数据源public class Record{int id;DateTime birth;string name, sex, remark;float math, chinese, english;public Record(int id, string name, string sex, DateTime birth, float math, float chinese, float english, string remark){this.id = id;this.name = name;this.sex = sex;this.birth = birth;this.math = math;this.chinese = chinese;this.english = english;this.remark = remark;}public int ID { get { return id; } }public string Name{get { return name; }set { name = value; }}public string Sex{get { return sex; }set { sex = value; }}public DateTime Birth{get { return birth; }set { birth = value; }}public float Math{get { return math; }set { math = value; }}public float Chinese{get { return chinese; }set { chinese = value; }}public float English{get { return english; }set { english = value; }}public string Remark{get { return remark; }set { remark = value; }}}#endregion}}