如何获得一个总和datagridview列asp.net [英] how to get a sum datagridview column asp.net

问题描述

这是我的Gridview和bind method.plz帮助满足获得Value，Duty，Fuel Colums的总和。

This my Gridview and bind method.plz help met get sum of Value,Duty,Fuel Colums.

protected void btn_Cash_Ok_Click(object sender, EventArgs e)
        {
        for (int i = 0; i < Cusinvoicegrid.Rows.Count; i++)
            {
        if ((Cusinvoicegrid.Rows[i].Cells[8].FindControl("CB_replace")CheckBox).Checked == true)
          {
                 if (Session["dt1"] != null) dt1 = (DataTable)Session["dt1"];
                 DataRow dr = dt1.NewRow();
                 dr["HAWB"] = Cusinvoicegrid.Rows[i].Cells[1].Text;//1 
                 dr["MANIWEIGHT"] = Cusinvoicegrid.Rows[i].Cells[2].Text;//2
                 dr["Value"] = Cusinvoicegrid.Rows[i].Cells[4].Text;//3
               TextBox Duty = (TextBox)Cusinvoicegrid.Rows[i].Cells[5].FindControl("txtfuel");  
               dr["Duty"] = double.Parse(Duty.Text);

               TextBox Extra = (TextBox)Cusinvoicegrid.Rows[i].Cells[6].FindControl("TextBox1");
               dr["Extra"] = double.Parse(Extra.Text);//5

               Double surcharge = rv.getSurchargeRate();
               Double SR = Math.Round((Double.Parse(Cusinvoicegrid.Rows[i].Cells[4].Text)) * (surcharge / 100), 2);
                    dr["Fuel"] = SR;//6 SR;
                    dt1.Rows.Add(dr);

                    Cusinvoicegrid0.DataSource = dt1;
                    Cusinvoicegrid0.DataBind();                 
                }
            }
        }

推荐答案

如何-I-能出现最总和法中-A-datagridview的列 [ ^ ]



计算-Data-values-from-DataGridView.aspx [ ^ ]



查看此链接..



甚至你可以参考结果 [ ^ ]

how-i-can-show-the-sum-of-in-a-datagridview-column[^]

Calculating-The-Sum-values-from-DataGridView.aspx[^]

Check this links..

and even u can refer the results[^]

这篇关于如何获得一个总和datagridview列asp.net的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！