how to get opening and closing balance using datagridview

Hello, i want to show the opening and closing balance in datagridview.

so, i tried below code on datagridview's sorted event.

private void dataGridView1_Sorted(object sender, EventArgs e)
{
try
{
for (int i = 1; i < dataGridView1.Rows.Count - 1; i++)
{
if (dataGridView1.Rows[i].Cells[4].Value.ToString() != "0")
{
dataGridView1.Rows[i].Cells[5].Value = Convert.ToInt32(dataGridView1.Rows[i-1].Cells[5].Value) - Convert.ToInt32(dataGridView1.Rows[i].Cells[4].Value);
}
else
{
dataGridView1.Rows[i].Cells[5].Value = Convert.ToInt32(dataGridView1.Rows[i - 1].Cells[5].Value) + Convert.ToInt32(dataGridView1.Rows[i].Cells[1].Value);
}
}
}
catch (Exception ex)
{
}
}

it show's me this type of output in datagridview which i displayed in below image

But as per my requirement i want this type of output in datagridview

so help how can i do this ?

1 Reply

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

Laxmidhar Sahoo7y ago
Accepted answer
dataGridView1.Rows[i].Cells[5].Value = (Convert.ToInt32(dataGridView1.Rows[i - 1].Cells[5].Value) + Convert.ToInt32(dataGridView1.Rows[i].Cells[1].Value) )- Convert.ToInt32(dataGridView1.Rows[i].Cells[4].Value);
+1