作者j88lb (尿布)
看板Visual_Basic
标题[ASP ] Gridview 分页 总计问题
时间Tue Jan 17 17:17:29 2012
不好意思又来请教各位~
目前在做gridview连结access资料库时遇到的问题
程式码如下：
Dim priceTotal3 As Decimal = 0
Dim quantityTotal3 As Decimal = 0
Protected Sub GridView13_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView13.RowDataBound
If e.Row.RowType = DataControlRowType.DataRow Then
priceTotal3 += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, _
"cost"))
quantityTotal3 += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, _
"num"))
ElseIf e.Row.RowType = DataControlRowType.Footer Then
e.Row.Cells(0).Text = "小计:"
e.Row.Cells(3).Text = quantityTotal3.ToString("d")
e.Row.Cells(4).Text = priceTotal3.ToString("c")
e.Row.Cells(3).HorizontalAlign = HorizontalAlign.Right
e.Row.Cells(4).HorizontalAlign = HorizontalAlign.Right
e.Row.Font.Bold = True
End If
End Sub
这样的写法只能呈现出每个分页的加总在footer上
请问要如何将分页的小计作加总呢??
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 140.120.98.114
1F：推 brian90191:其实我建议你直接针对你的资料来源做处理 01/17 23:33
2F：→ j88lb:我是用access的资料库 请问可以抓取里面的总和资料嘛? 01/18 14:59
3F：推 TeemingVoid:select sum(栏位名称) from 资料表名称 where ... 01/18 21:24