add operation on multiple rows specific cells of DataGridVie

Hello @sureshma you can write the code for DataBindingComplete event. Try this:

 

 

private void dataGridView1_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
int Amount = 0;
foreach (DataGridViewRow gr in dataGridView1.Rows)
{
string str = gr.Cells[2].Value.ToString();
if (str.Contains("Dr."))
Amount -= int.Parse(str.Substring(0, str.Length - 3));
else
Amount += int.Parse(str.Substring(0, str.Length - 3));
}
if (Amount > 0)
textBox1.Text = Amount.ToString() + " Cr";
else
{
Amount = Amount * -1;
textBox1.Text = Amount.ToString() + "Dr";
}
}