Xgrid binding)

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 xtr1_ddemo1
11. {
12. Public partial class form1: devexpress. xtraeditors. xtraform
13. {
14. Public form1 ()
15. {
16. Initializecomponent ();
18. // Drag the gridcontrol to the form, click "Click here to change View", and select "convert to" --> "advbandedgridview" in the pop-up menu ".
    
20. Initgrid ();
21. }
23. /// Initialize the table
24. Private void initgrid ()
25. {
27. // Advbandedgridview1 is the default view on the table. Note that: bandedgridview is declared here.
28. Bandedgridview view = advbandedgridview1 as bandedgridview;
30. View. beginupdate (); // edit the start view to prevent other events from being triggered.
31. View. begindataupdate (); // start data editing
    
33. View. bands. Clear ();
35. // Modify additional options
36. View. optionsview. showcolumnheaders = false; // The columnheader is hidden because the band Column exists.
37. View. optionsview. showgrouppanel = false; // remove the group if it is not necessary.
38. View. optionsview. enableappearanceevenrow = false; // whether to enable the appearance of even rows
39. View. optionsview. enableappearanceoddrow = true; // whether to enable the appearance of odd rows
40. View. optionsview. showfilterpanelmode = showfilterpanelmode. Never; // whether to display the filter panel
41. View. optionscustomization. allowcolumnmoving = false; // whether to allow column Movement
42. View. optionscustomization. allowcolumnresizing = false; // whether the column width can be adjusted
43. View. optionscustomization. allowgroup = false; // whether to allow grouping
44. View. optionscustomization. allowfilter = false; // whether to allow filtering
45. View. optionscustomization. allowsort = true; // whether sorting is allowed
46. View. optionsselection. enableappearancefocusedcell = true ;//???
47. View. optionsbehavior. editable = true; // whether to allow users to edit Cells
    
49. // Add a column title
50. Gridband bandid = view. bands. addband ("ID ");
51. Bandid. Visible = false; // hide the ID column
52. Gridband bandname = view. bands. addband ("name ");
53. Gridband bandsex = view. bands. addband ("gender ");
54. Gridband bandbirth = view. bands. addband ("Date of Birth ");
55. Gridband bandscore = view. bands. addband ("score ");
56. Gridband bandmath = bandscore. Children. addband ("Mathematics ");
57. Gridband bandchinese = bandscore. Children. addband (" ");
58. Gridband bandenglish = bandscore. Children. addband ("English ");
59. Gridband bandsubtotal = bandscore. Children. addband ("subtotal ");
60. Gridband bandremark = view. bands. addband ("Remarks ");
62. // Column Title alignment
63. Bandname. appearanceheader. textoptions. halignment = devexpress. utils. horzarignment. Center;
64. Bandsex. appearanceheader. textoptions. halignment = devexpress. utils. horzarignment. Center;
65. Bandbirth. appearanceheader. textoptions. halignment = devexpress. utils. horzarignment. Center;
66. Bandscore. appearanceheader. textoptions. halignment = devexpress. utils. horzarignment. Center;
67. Bandmath. appearanceheader. textoptions. halignment = devexpress. utils. horzarignment. Center;
68. Bandchinese. appearanceheader. textoptions. halignment = devexpress. utils. horzarignment. Center;
69. Bandenglish. appearanceheader. textoptions. halignment = devexpress. utils. horzarignment. Center;
70. Bandsubtotal. appearanceheader. textoptions. halignment = devexpress. utils. horzarignment. Center;
71. Bandremark. appearanceheader. textoptions. halignment = devexpress. utils. horzarignment. Center;
73. // Simulate several data items
74. List <record> listdatasource = new list <record> ();
    
75. Listdatasource. Add (New Record (1, "Zhang San", "male", 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, "Zhao ", "male", convert. todatetime ("1988-9-1"), 119,108,110, "Remarks "));
79. // Bind and display the data source
    
80. Gridcontrol1.datasource = listdatasource;
81. Gridcontrol1.mainview. populatecolumns ();
83. // [Subtotal] because this column is not bound to the data source, you need to manually add
84. // (It's a bit complicated. Take a look)
85. String [] fieldnames = new string [] {"subtotal "};
86. Gridcolumn column; // declare a single column
87. Column = view. Columns. addfield (fieldnames [0]); // Add a data field
88. Column. visibleindex = view. Columns. Count-1; // sets the position of the column when editing the view (the second to last column)
    
89. Column. unboundtype = devexpress. Data. unboundcolumntype. Decimal;
90. Column. optionscolumn. allowedit = false; // This column cannot be edited.
91. Column. Visible = true;
92. View. Columns. Add (column); // Add a column to the view.
94. // Bind the event. When the [score] changes, the [subtotal] also changes.
95. // (It seems that the cell value can be changed only in the binding event, and the direct modification is invalid)
96. View. customunboundcolumndata + = new
97. Devexpress. xtragrid. Views. Base. customcolumndataeventhandler (advbandedgridview1_munmunboundcolumndata );
99. // Bind the [gender] column to ComboBox
100. Repositoryitemcombobox ricombo = new repositoryitemcombobox ();
101. Ricombo. Items. addrange (New String [] {"male", "female "});
102. Gridcontrol1.repositoryitems. Add (ricombo );
103. View. Columns ["sex"]. columnedit = ricombo;
105. // [Date of Birth] column bound to date
106. Repositoryitemdateedit ridate = new repositoryitemdateedit ();
107. Gridcontrol1.repositoryitems. Add (ridate );
108. View. Columns ["birth"]. columnedit = ridate;
110. // Bind the [score] column to 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. // Bind the [Remarks] column to memoexedit
118. Repositoryitemmemoexedit rimemoex = new repositoryitemmemoexedit ();
119. Gridcontrol1.repositoryitems. Add (rimemoex );
120. View. Columns ["remark"]. columnedit = rimemoex;
122. // Add a summary in the subtotal Column
123. View. optionsview. showfooter = true; // display the table footer
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. // Match the title column with the data column
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 (); // end data editing
140. View. endupdate (); // edit the end view
143. }
146. // Calculate the subtotal
147. Private float calcsubtotal (float math, float Chinese, float English)
148. {
149. Return math + Chinese + English;
150. }
152. Private void advbandedgridview1_munmunboundcolumndata (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. # Bind region to the data source that implements the ilist interface during runtime
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. }

Xgrid binding)