See the screen shoot and help me to sum

Rafnas T P9y ago

Accepted answer

try below code

double sum = 0;
foreach (DataGridViewRow g1 in dataGridView.Rows)
{
if (g1.Cells[1].Value.ToString()=="Placid Express")
sum= sum+ Convert.ToDouble(g1.Cells[2].Value);
}
MessageBox.Show("Sum = "+ sum);

here sum is your output

Shovan Saha9y ago

But getting problem such as:

An unhandled exception of type 'System.FormatException' occurred in mscorlib.dll

Additional information: Input string was not in a correct format.

Yogendra Bhardwaj9y ago

int sum = 0;
foreach (DataGridViewRow row in dataGridView.Rows)
{
if(row.Cells[0].Value=='Placid Express')
sum += (int) row.Cells[2].Value;
}

MessageBox.Show("Sum of all the values is {0}", sum.ToString());

Sl	SuspenceAccount	AmountBDT
1	Placid Express	30
2	Prabhu Group	40
3	Placid Express	20
4	Ria Financial	70
5	Placid Express	50