代碼生成gv
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 |
grvSum.Columns.Clear(); DataTable dt = SqlHelper.ExecuteDataSet(conn, CommandType.StoredProcedure, "cerModule_IndentDetailInfo" , parms).Tables[0]; BoundField bfProductName = new BoundField(); bfProductName.HeaderText = "商品名稱" ; bfProductName.DataField = "商品名稱" ; grvSum.Columns.Add(bfProductName); BoundField bfProductNum = new BoundField(); bfProductNum.HeaderText = "商品數(shù)量" ; bfProductNum.DataField = "商品數(shù)量" ; grvSum.Columns.Add(bfProductNum); BoundField bfProductUnit = new BoundField(); bfProductUnit.HeaderText = "商品單位" ; bfProductUnit.DataField = "商品單位" ; grvSum.Columns.Add(bfProductUnit); BoundField bfProductPrice = new BoundField(); bfProductPrice.HeaderText = "商品單價(jià)" ; bfProductPrice.DataField = "商品單價(jià)" ; grvSum.Columns.Add(bfProductPrice); TemplateField tfSum = new TemplateField(); Label lblSum = new Label(); tfSum.ItemTemplate = new sumTemplateField(); tfSum.HeaderText = "合計(jì)" ; tfSum.ShowHeader = true ; grvSum.Columns.Add(tfSum); grvSum.DataSource = dt; grvSum.DataBind(); |