1
/// <summary>
2
/// 列得表达式求值
3
/// 孙二永20070612
4
/// </summary>
5
/// <param name="sender"></param>
6
/// <param name="e"></param>
7
private void Button2_Click(object sender, System.EventArgs e)
8
{
9
10
DataTable table = new DataTable ();
11![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
12
//创建table的第一列
13
DataColumn priceColumn = new DataColumn();
14
//该列的数据类型
15
priceColumn.DataType = System.Type.GetType("System.Decimal");
16
//该列得名称
17
priceColumn.ColumnName = "price";
18
//该列得默认值
19
priceColumn.DefaultValue = 50;
20![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
21
// 创建table的第二列
22
DataColumn taxColumn = new DataColumn();
23
taxColumn.DataType = System.Type.GetType("System.Decimal");
24
//列名
25
taxColumn.ColumnName = "tax";
26
//设置该列得表达式,用于计算列中的值或创建聚合列
27
taxColumn.Expression = "price * 0.0862";
28
29![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
30
// Create third column.
31
DataColumn totalColumn = new DataColumn();
32![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
33
totalColumn.DataType = System.Type.GetType("System.Decimal");
34![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
35
totalColumn.ColumnName = "total";
36
//该列的表达式,值是得到的是第一列和第二列值得和
37
totalColumn.Expression = "price + tax";
38![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
39
// 将所有的列添加到table上
40
table.Columns.Add(priceColumn);
41
table.Columns.Add(taxColumn);
42
table.Columns.Add(totalColumn);
43![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
44
//创建一行
45
DataRow row = table.NewRow();
46![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
47
//将此行添加到table中
48
table.Rows.Add(row);
49![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
50
//将table放在试图中
51
DataView view = new DataView(table);
52![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
53
dg.DataSource = view;
54![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
55
dg.DataBind();
56
57
58![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
59![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
60
61![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
62
}
63![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
2
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
3
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
4
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
5
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
6
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
7
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
8
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
9
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
10
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
11
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
12
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
13
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
14
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
15
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
16
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
17
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
18
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
19
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
20
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
21
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
22
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
23
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
24
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
25
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
26
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
27
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
28
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
29
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
30
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
31
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
32
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
33
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
34
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
35
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
36
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
37
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
38
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
39
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
40
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
41
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
42
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
43
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
44
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
45
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
46
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
47
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
48
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
49
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
50
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
51
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
52
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
53
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
54
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
55
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
56
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
57
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
58
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
59
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
60
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
61
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
62
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
63
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)