Datagridveiw column sum

Question

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

Vulpes · 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 kakuru · Answer

thanks vulpes, it has worked very well.

Marvin kakuru · Answer

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'

Vulpes · Answer

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 kakuru · Answer

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

Vulpes · Answer

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");