如果我要统计所有绑定在datagrid的用户工资的总和,应该如何写代码?
麻烦大家看看以下代码,如果我要统计所有绑定在datagrid的用户工资 的总和,应该如何写代码?????????????????????
麻烦朋友帮忙,我只想知道如何做DATAGRID的统计?我看了些例子但还是无从下手.如谁愿意帮忙,100全加于谁!!!!!!!!!!!!!!!!!!!!!!!!!!!!
<% @ Page Language="VB" ContentType="text/html" trace="true" %>
<% @ Import Namespace="System.Data" %>
<% @ import namespace="saleNS" %>
<% @ Import Namespace="System.Data.OleDb" %>
<% @ Import Namespace="System.Web.Security" %>
<script language="VB" runat=server>
Sub page_load(sender As object,e As eventargs)
Dim db As SQLCLASS = New SQLCLASS()
Dim sql As String = "select * from tab_relation"
Dim dv As DataView = db.GetDataView(sql,"tab_relation")
DataGrid1.DataSource = dv
DataGrid1.DataBind()
End sub
</script>
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
</HEAD>
<BODY>
<Form runat="server">
<asp:DataGrid id="DataGrid1" runat="server"
HeaderStyle-BackColor="#aaaadd"
AlternatingItemStyle-BackColor="#eeeeee"
AllowSorting="True"
AutoGenerateColumns="False"
>
<Columns>
<asp:BoundColumn HeaderText="用户名称" DataField="user_name" SortExpression="user_name" ItemStyle-Width="50pt"/>
<asp:BoundColumn HeaderText="用户工资" DataField="user_wage" SortExpression="sup_name" />
</Columns>
</asp:DataGrid>
</form>
</BODY>
</HTML>