再发,计算DataGrid某一列的总和!
Code:
string MemberID=null;
MemberID=Request.Cookies["Member_ID"].Value;
SqlConnection Conn=DB_Operate.Create_Connection();
Conn.Open();
SqlDataAdapter Manage_Order_Cmd=new SqlDataAdapter("Select * From Order_Code Where Member_ID='"+MemberID+"' Order By Order_Code Desc",Conn);
DataSet DS=new DataSet();
Manage_Order_Cmd.Fill(DS,"Order_Code");
this.Manage_Order_DataGrid.DataKeyField="Order_Code";
this.Manage_Order_DataGrid.DataSource=DS.Tables["Order_Code"].DefaultView;
this.Manage_Order_DataGrid.DataBind();
//获取会员报单总记录数
string OrderRecord=this.Manage_Order_DataGrid.Items.Count.ToString();
this.Order_Record.Text=OrderRecord;
int sum=0;
foreach(System.Web.UI.WebControls.DataGridItem lsItem in this.Manage_Order_DataGrid.Items)
{
if(lsItem.ItemIndex>=0)
{
sum+=int.Parse(lsItem.Cells[3].Text);
}
}
this.Order_Total_Money.Text=sum.ToString();
Datagrid Html代码:
<asp:datagrid id="Manage_Order_DataGrid" runat="server" AllowPaging="True" Width="600px" AutoGenerateColumns="False"
DataKeyField="Order_Code" CellPadding="1" BorderWidth="1px" BorderStyle="Solid" BorderColor="#698CC3">
<SelectedItemStyle Font-Bold="True" ForeColor="White" BackColor="#008A8C"></SelectedItemStyle>
<AlternatingItemStyle BackColor="#F0F0F0"></AlternatingItemStyle>
<ItemStyle BackColor="#FEFEFE"></ItemStyle>
<HeaderStyle Font-Bold="True" ForeColor="White" BackColor="#698CC3"></HeaderStyle>
<Columns>
<asp:TemplateColumn HeaderText="会员号">
<HeaderStyle HorizontalAlign="Center" ForeColor="White" Width="100px"></HeaderStyle>
<ItemTemplate>
<div align="center"><%#DataBinder.Eval(Container.DataItem,"Member_ID")%>
</div>
</ItemTemplate>
</asp:TemplateColumn>
<asp:BoundColumn DataField="Order_Code" HeaderText="订单号">
<HeaderStyle HorizontalAlign="Center" ForeColor="White" Width="400px"></HeaderStyle>
<ItemStyle Width="500px"></ItemStyle>
</asp:BoundColumn>
<asp:TemplateColumn HeaderText="编辑">
<HeaderStyle ForeColor="White" Width="40px"></HeaderStyle>
<ItemTemplate>
<a href='Edit_Order.aspx?Order_Code=<%# DataBinder.Eval(Container.DataItem, "Order_Code")%>'>
修改</a>
</ItemTemplate>
</asp:TemplateColumn>
<asp:ButtonColumn Text="删除" HeaderText="删除" CommandName="Delete">
<HeaderStyle ForeColor="White" Width="40px"></HeaderStyle>
</asp:ButtonColumn>
</Columns>
<PagerStyle HorizontalAlign="Center" Mode="NumericPages"></PagerStyle>
</asp:datagrid>
每次运行都说输入的字符串格式不正确
数据表:
Member_ID Product_Code Product_Num Total_Money
001 BW001 10 100
001 BW002 20 45
我要计算Total_Money的总和