Click here to Skip to main content
15,891,828 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
52.02


What I have tried:

C#
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
Posted
Updated 1-Jan-20 23:27pm
v3
Comments
Richard MacCutchan 6-Dec-18 4:39am    
What is the problem?

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
 
Share this answer
 
v2
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");
 
Share this answer
 
v2

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