c# DataGridView添加合计行的例子

      private void Form1_Load(object sender, EventArgs e)
        {          
            dataGridView1.DataSource = GetData();    
        }
     private void button1_Click(object sender, EventArgs e) 
     {
         DataGridView gw =dataGridView1;
         Total(gw);
     }
     //合计行
     public void Total(DataGridView dg)
     {     
         DataGridViewRow dgr = dg.Rows[dg.Rows.Count - 1];
         dgr.ReadOnly = true;       
         dgr.Cells[0].Value = "合计";
         for (int i = 0; i < dg.Rows.Count - 1; i++)
         {
             dgr.Cells[2].Value = Convert.ToSingle(dgr.Cells[2].Value) + Convert.ToSingle(dg.Rows[i].Cells[2].Value);
         }
     }
   
      private System.Data.DataTable GetData()
     {
         System.Data.DataTable tableInfo = new System.Data.DataTable();
 
         DataColumn dctime = new DataColumn("Time", Type.GetType("System.String"));
         DataColumn dcCity = new DataColumn("City", Type.GetType("System.String"));
         DataColumn dcCount = new DataColumn("Count", Type.GetType("System.Int32"));
         tableInfo.Columns.Add(dctime);
         tableInfo.Columns.Add(dcCity);
         tableInfo.Columns.Add(dcCount);
         DataRow dr = tableInfo.NewRow();
         dr["Time"] = "1:00";
         dr["City"] = "10";
         dr["Count"] = "15";
         tableInfo.Rows.Add(dr);
         DataRow dr1 = tableInfo.NewRow();
         dr1["Time"] = "2:00";
         dr1["City"] = "12";
         dr1["Count"] = "19";
         tableInfo.Rows.Add(dr1);
         DataRow dr2 = tableInfo.NewRow();
         dr2["Time"] = "3:00";
         dr2["City"] = "13";
         dr2["Count"] = "25";
         tableInfo.Rows.Add(dr2);
         DataRow dr3 = tableInfo.NewRow();
         dr3["Time"] = "4:00";
         dr3["City"] = "14";
         dr3["Count"] = "10";
         tableInfo.Rows.Add(dr3);
 
         DataRow dr4 = tableInfo.NewRow();
         dr4["Time"] = "5:00";
         dr4["City"] = "15";
         dr4["Count"] = "11";
         tableInfo.Rows.Add(dr4);
 
         DataRow dr5 = tableInfo.NewRow();
         dr5["Time"] = "6:00";
         dr5["City"] = "16";
         dr5["Count"] = "17";
         tableInfo.Rows.Add(dr5);
 
         DataRow dr6 = tableInfo.NewRow();
         dr6["Time"] = "7:00";
         dr6["City"] = "17";
         dr6["Count"] = "20";
         tableInfo.Rows.Add(dr6);
 
         DataRow dr7 = tableInfo.NewRow();
         dr7["Time"] = "8:00";
         dr7["City"] = "12";
         dr7["Count"] = "13";
         tableInfo.Rows.Add(dr7);
         return tableInfo;
     }

  • 0
    点赞
  • 6
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值