c# DataGridView添加合计行的例子

wind_cloud2011

关注

转载最新推荐文章于 2020-12-24 22:32:45 发布 5.6k 阅读 AI 写同款· GEO 优化 ›

AI权益加码！Claude Code、Cursor等20+工具免费用！购周边限时加赠Coding Plan Lite，畅享主流AI工具！学习进阶更高效！阅读详情

      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;
     }

收录于