XGrid绑定(转)

1. 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;
   10. namespace XtraGridDemo1
   11. {
   12. public partial class Form1 : DevExpress.XtraEditors.XtraForm
   13. {
   14. public Form1()
   15. {
   16. InitializeComponent();
   18. //首先拖到窗体上一个GridControl，在表格上点击“Click here to change view”链接，在弹出菜单中选择“convert to”-->“AdvBandedGridView”。
       
   20. InitGrid();
   21. }
   23. ///初始化表格
   24. private void InitGrid()
   25. {
   27. // advBandedGridView1是表格上的默认视图，注意这里声明的是：BandedGridView
   28. BandedGridView view = advBandedGridView1 as BandedGridView;
   30. view.BeginUpdate(); //开始视图的编辑，防止触发其他事件
   31. view.BeginDataUpdate(); //开始数据的编辑
       
   33. view.Bands.Clear();
   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; //是否允许用户编辑单元格
       
   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("备注");
   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;
   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();
   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); //视图中添加一列
   94. //绑定事件，当[分数]改变时[小计]也跟着变
   95. //(好像只有在绑定事件里才能改变该单元格数值，直接修改无效)
   96. view.CustomUnboundColumnData += new
   97. DevExpress.XtraGrid.Views.Base.CustomColumnDataEventHandler(advBandedGridView1_CustomUnboundColumnData);
   99. //[性别]列绑定ComboBox
   100. RepositoryItemComboBox riCombo = new RepositoryItemComboBox();
   101. riCombo.Items.AddRange(new string[] {"男", "女"});
   102. gridControl1.RepositoryItems.Add(riCombo);
   103. view.Columns["Sex"].ColumnEdit = riCombo;
   105. //[出生年月]列绑定Date
   106. RepositoryItemDateEdit riDate = new RepositoryItemDateEdit();
   107. gridControl1.RepositoryItems.Add(riDate);
   108. view.Columns["Birth"].ColumnEdit = riDate;
   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;
   117. //[备注]列绑定MemoExEdit
   118. RepositoryItemMemoExEdit riMemoEx = new RepositoryItemMemoExEdit();
   119. gridControl1.RepositoryItems.Add(riMemoEx);
   120. view.Columns["Remark"].ColumnEdit = riMemoEx;
   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;
   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;
   139. view.EndDataUpdate();//结束数据的编辑
   140. view.EndUpdate(); //结束视图的编辑
   143. }
   146. // 计算小计
   147. private float calcSubTotal(float math, float chinese, float english)
   148. {
   149. return math + chinese + english;
   150. }
   152. private void advBandedGridView1_CustomUnboundColumnData(object sender, CustomColumnDataEventArgs e)
   153. {
   154. ColumnView colView = sender as ColumnView;
   155. if (e.Column.FieldName == "SubTotal" && e.IsGetData) e.Value = calcSubTotal(
   156. Convert.ToSingle(colView.GetRowCellValue(e.RowHandle, colView.Columns["Math"])),
   157. Convert.ToSingle(colView.GetRowCellValue(e.RowHandle, colView.Columns["Chinese"])),
   158. Convert.ToSingle(colView.GetRowCellValue(e.RowHandle, colView.Columns["English"])));
   159. }
   162. #region 运行时绑定到实现Ilist接口的数据源
   164. public class Record
   165. {
   166. int id;
   167. DateTime birth;
   168. string name, sex, remark;
   169. float math, chinese, english;
   170. public Record(int id, string name, string sex, DateTime birth, float math, float chinese, float english, string remark)
   171. {
   172. this.id = id;
   173. this.name = name;
   174. this.sex = sex;
   175. this.birth = birth;
   176. this.math = math;
   177. this.chinese = chinese;
   178. this.english = english;
   179. this.remark = remark;
   180. }
   181. public int ID { get { return id; } }
   182. public string Name
   183. {
   184. get { return name; }
   185. set { name = value; }
   186. }
   187. public string Sex
   188. {
   189. get { return sex; }
   190. set { sex = value; }
   191. }
   192. public DateTime Birth
   193. {
   194. get { return birth; }
   195. set { birth = value; }
   196. }
   197. public float Math
   198. {
   199. get { return math; }
   200. set { math = value; }
   201. }
   202. public float Chinese
   203. {
   204. get { return chinese; }
   205. set { chinese = value; }
   206. }
   207. public float English
   208. {
   209. get { return english; }
   210. set { english = value; }
   211. }
   212. public string Remark
   213. {
   214. get { return remark; }
   215. set { remark = value; }
   216. }
   218. }
   220. #endregion
   222. }
   223. }

转载于:https://www.cnblogs.com/zzh1236/p/4024643.html