如何在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