This repository has been archived by the owner on Sep 11, 2023. It is now read-only.
/
Form_GridControl.cs
57 lines (53 loc) · 2.16 KB
/
Form_GridControl.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
using DevExpress.XtraGrid.Columns;
using System;
using System.Data;
using System.Collections.Generic;
using System.IO;
using System.Linq;
namespace Standalone_ExpressionEditor
{
public partial class Form_GridControl : DevExpress.XtraEditors.XtraForm
{
public Form_GridControl() {
InitializeComponent();
gridControl1.DataSource = GetData();
AddUnboundColumns();
PopulateComboWithUnboundColumns();
comboBoxEdit1.EditValue = "Expression A";
}
private void comboBoxEdit1_SelectedIndexChanged(object sender, EventArgs e) {
GridColumn unboundColumn = gridView1.Columns[comboBoxEdit1.EditValue.ToString()];
unboundExpressionPanel1.StartEdit(unboundColumn);
}
void AddUnboundColumns() {
GridColumn col1 = gridView1.Columns.AddVisible("Expression A");
col1.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
col1.UnboundExpression = "[UnitPrice] * [UnitsInStock]";
GridColumn col2 = gridView1.Columns.AddVisible("Expression B");
col2.UnboundType = DevExpress.Data.UnboundColumnType.Object;
}
void PopulateComboWithUnboundColumns() {
foreach (GridColumn col in gridView1.Columns) {
if (col.UnboundType != DevExpress.Data.UnboundColumnType.Bound)
comboBoxEdit1.Properties.Items.Add(col.FieldName);
}
}
DataTable GetData() {
if (File.Exists("northwind_data.xml")) {
DataSet ds = new DataSet();
ds.ReadXml("northwind_data.xml", XmlReadMode.ReadSchema);
return ds.Tables[0];
} else {
DataTable dt = new DataTable();
dt.Columns.Add("ID", typeof(int));
dt.Columns.Add("Info", typeof(string));
dt.Columns.Add("UnitPrice", typeof(decimal));
dt.Columns.Add("UnitsInStock", typeof(int));
for (int i = 0; i < 6; i++) {
dt.Rows.Add(i, "Info" + i, 3.37 * (i + 1), i + 3);
}
return dt;
}
}
}
}