Conditionally add empty row

[Felice]

I will be really glad if I can get some direction on this:
I have a radGridView in a winform in which I have also 4 decimal columns of which 1 (Balance) is calculated with an expression (Balance=Paid-Due+Expenses). All columns are bound to an sql table.
Id-----Date------Due-----Paid-----Expenses-----Balance

How can I generate a new empty row just below the active row if the value of balance is different than 0?
The problems I have are:
-how to get the value contained in "Balance" of the active row
-how to add a row below the active row

Thanks a lot,
Felice
 

[George]

Hello Falice,

Thank you for contacting us.

In order to get the value of the Balance cell in the current row you can use the following code:

object cellValue = this.grid.CurrentRow.Cells["Balance"].Value;
if (cellValue != null)
{
    string valueAsString = cellValue.ToString();
    decimal value = decimal.Parse(valueAsString);
}

And in order to add a row after the current row you can use the Insert method of the Rows collection:

GridViewRowInfo newRow = new GridViewRowInfo(this.grid.MasterView);
this.grid.Rows.Insert(this.grid.CurrentRow.Index + 1, newRow);

I hope this helps.

Regards,
George
Telerik