Running Total like a Check Register

[Doug Odegaard]

Has anyone achieved a running total innately in the RadGrid that acts like a checkbook-register or does it truly need to be a backend cursor operation to achieve this look and feel.  i need to place a "Balance" on the last column that adds-subtracts a value in another column over time.

Thanks in advance.
Doug

[Doug Odegaard]

Well....I figured it out but here it is if anyone needs it....wire up the ItemDataBound event with a page level variable keeping totals

protected void RadGrid1_ItemDataBound1(object sender, GridItemEventArgs e)

{

if (e.Item is GridDataItem)

{

GridDataItem dataItem = e.Item as GridDataItem;

string payment = dataItem["PaymentAmount"].Text;

decimal fieldValue = decimal.Parse(payment);

total += fieldValue;

dataItem["Balance"].Text = total.ToString();

}

if (e.Item is GridFooterItem)

{

GridFooterItem footerItem = e.Item as GridFooterItem;

footerItem["PaymentAmount"].Text = "total: " + total.ToString();

}

}