Click here to Skip to main content
14,732,982 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I want the answer like this:
Column A	Column B	Column C
12.02	         10.00	         22.02
32.02            10.00           42.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();
when i try this code 1st row 1st column is changing.want to display the sum in 2nd row 1st column and continuously
Updated 2-Jan-20 0:27am
Richard MacCutchan 6-Dec-18 4:39am
What is the problem?

See answers here: Math calculation in datagrid view[^]
You can do it using for loop but if you want to do it in one line.
long sum = (long)DgView.Compute("Sum(Column A)", "True");

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900