c# - 如何对datagridview末尾的列求和

Question

我想对 DataGridView 末尾的列求和，如下所示:

      column1 | column2  |column3|  column3   |
      --------+----------+-------+------------|
      1       | 2        |    3  |     4      |
     ---------+----------+-------+------------|
      2       |  4       |     7 |      9     |
--------------+----------+-------+------------|
total 3        6           10         13
-----------------------------------------------

Answer 1

您可以在 gridview 的页脚添加总计:

 decimal total = dt.AsEnumerable().Sum(row => row.Field<decimal>("Amount"));
                    GridView1.FooterRow.Cells[1].Text = "Total";
                    GridView1.FooterRow.Cells[1].HorizontalAlign = HorizontalAlign.Right;
                    GridView1.FooterRow.Cells[2].Text = total.ToString("N2");