Datagridveiw column sum

Marvin kakuru

Hi all,
I hope your all alright. I am designing a cash denomination calculator and below is the code I have used.
private void dataGridView1_CellValidated_1(object sender, DataGridViewCellEventArgs e)

{

DataGridViewRow row = dataGridView1.Rows[e.RowIndex]
int a = System.Convert.ToInt32(row.Cells[ColumnA.Index].Value);
int b = System.Convert.ToInt32(row.Cells[ColumnB.Index].Value);
int c = (a * b);
row.Cells[ColumnC.Index].Value = c.ToString("n0");

dataGridView1.Columns["ColumnB"].Width = 170;
dataGridView1.Columns["ColumnC"].Width = 200;

}

However I have failed to find a way of getting the sum of the values for all rows of column, Is there a way I can get the sum of all rows of a column of a datagridview and display it in a textbox.text or a label.text

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes15y ago
Accepted answer
Ah, that's just an error on my part.

This line:

foreach(DataRow row in dataGridView1.Rows)

should be:

foreach(DataGridViewRow row in dataGridView1.Rows)

Apologies for that :(
Marvin kakuru15y ago
thanks vulpes, it has worked very well.
Marvin kakuru15y ago
yeah i actually want to add up all the rows column C. below are the errors i am getting.

'System.Data.DataRow' does not contain a definition for 'IsNewRow' and no extension method 'IsNewRow'
'System.Data.DataRow' does not contain a definition for 'Cells' and no extension method 'Cells'
Vulpes15y ago
Actually, Marvin, I did think your question was reasonably clear : iterate through the rows and add up the values in ColumnC which hopefully is what I've done :)

Did you in fact want to add up something else instead of (or in addition to) that?
Marvin kakuru15y ago
hai vulpes sorry sorry, i was actually requesting for help on how to get the sum of all cells of Column C.

this code has worked though for the sum of all cells in the row.
sorry i asked a confusing question
Vulpes15y ago
Off the top of my head, I'd try:

int total = 0;
int val = 0;

foreach(DataRow row in dataGridView1.Rows)
{
if (row.IsNewRow) continue;
int.TryParse(row.Cells[ColumnC.Index].Value.ToString().Replace(",", ""), out val);
total += val;
}

textBox1.Text = total.ToString("n0");