在c＃中以编程方式在GridView的底部添加一行

Question

我想在GridView的末尾添加一行，该曲线截至目前有5列。末端行将表示每列的总数。我怎样才能做到这一点 ？这是我到目前为止尝试的。.我的行将具有nominedQuantity，分配的数字，卷，provisionalusd，profisionalkes

using (SqlDataAdapter sda = new SqlDataAdapter())
{
    cmd.CommandType = CommandType.StoredProcedure;
    cmd.Parameters.AddWithValue("@Country", "KENYATEST");
    cmd.Connection = con;
    sda.SelectCommand = cmd;
    using (dt = new DataTable())
    {
      sda.Fill(dt);
      foreach (DataRow dr in dt.Rows)
      {
          allocatedsum += Convert.ToInt32(dr["AllocatedQuantity"]);
          nominatedsum += Convert.ToInt32(dr["NominatedQuantity"]);
          volume += Convert.ToDouble(dr["Volume"]);
          ProvisionalUSD += Convert.ToInt32(dr["ProvisionalUSD"]);
          ProvisionalKES += Convert.ToInt32(dr["ProvisionalKES"]);
      }                       
      GridView1.DataSource = dt;    
      GridView1.DataBind();
    }                                  
}

Answer 1

您几乎在那里。您需要做的就是创建一个带有总值的新行，然后将其添加到数据表中。

using (SqlDataAdapter sda = new SqlDataAdapter())
        {
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@Country", "KENYATEST");
            cmd.Connection = con;
            sda.SelectCommand = cmd;
            using (dt = new DataTable())
            {
                sda.Fill(dt);
                foreach (DataRow dr in dt.Rows)
                {
                   allocatedsum += Convert.ToInt32(dr["AllocatedQuantity"]);
                   nominatedsum += Convert.ToInt32(dr["NominatedQuantity"]);
                   volume += Convert.ToDouble(dr["Volume"]);
                  ProvisionalUSD += Convert.ToInt32(dr["ProvisionalUSD"]);
                   ProvisionalKES += Convert.ToInt32(dr["ProvisionalKES"]);
                }
                //Create a row for totals over here
                DataRow totalRow = dt.NewRow();
                //Then set the total values inside this row
                totalRow["ColumnName"] = "Column Total"; //for each column
                dt.Rows.Add(totalRow); //finally add the new row to your dource datatable
                GridView1.DataSource = dt;
                GridView1.DataBind();
            }
} }

Answer 2

只需在将DT分配到数据源之前添加它...

 DataRow totalRow = dt.NewRow();
                totalRow["ColumnName"] = "Column Total"; 
                dt.Rows.Add(totalRow);