如何在C#中查找datagridview中的列总和

问题描述:

我想要这样的答案:

I want the answer like this:

Column A	Column B	Column C
12.02	         10.00	         22.02
32.02            10.00           42.02
52.02





我的尝试:





What I have tried:

private void DgView_CellValidated(object sender, DataGridViewCellEventArgs e)
        {
         if (DgView.CurrentCell.ColumnIndex == 0)
                {
                    DgView.Rows[DgView.CurrentCell.RowIndex].Cells[1].Value =                         cfun.convertdecimal(DgView.Rows[DgView.CurrentCell.RowIndex].Cells[0].Value.ToString())  + cfun.convertdecimal(txtValue.Text.ToString());
                }
}
 private void DgView_RowValidated(object sender, DataGridViewCellEventArgs e)
        {
            decimal sum = 0;

            for (decimal i = 0; i < DgView.Rows.Count+1; ++i)
            {
                sum = cfun.convertdecimal(DgView.Rows[DgView.CurrentCell.RowIndex].Cells[1].Value.ToString())
                     + cfun.convertdecimal(DgView.Rows[DgView.CurrentCell.RowIndex].Cells[2].Value.ToString());
            }
            DgView.Rows[DgASideView.CurrentCell.RowIndex].Cells[0].Value = sum.ToString();
        }

当我尝试这个代码时,第1行第1列正在改变。想要在第2行第1列显示总和并且连续

when i try this code 1st row 1st column is changing.want to display the sum in 2nd row 1st column and continuously

在此处查看答案:数据网格视图中的数学计算 [ ^ ]

并且:https://www.codeproject.com/Answers/1268855/How-to-sum-repeated-rows-in-datgridview-and-show-i#answer3
See answers here: Math calculation in datagrid view[^]
And: https://www.codeproject.com/Answers/1268855/How-to-sum-repeated-rows-in-datgridview-and-show-i#answer3