Calculated value from child records in UI for ASP.NET AJAX

This is a migrated thread and some comments may be shown as answers.

Calculated value from child records

4 Answers 43 Views

Grid

This is a migrated thread and some comments may be shown as answers.

4 Answers, 1 is accepted

answered on 22 Mar 2011, 04:49 PM

Hi Princy,

Thank you very much for your help.
I've tried with your suggestions but I'm unable to make it works.

This is the code that I'm trying in ItemDataBound event but it fails:

// Calculate Invoice Total column

if (e.Item.OwnerTableView.Name == "Master")

{

if (e.Item is GridDataItem)

{

GridDataItem item = (GridDataItem)e.Item;

decimal totalInvoice = 0;

GridTableView detailsTable = item.ChildItem.NestedTableViews[0];

foreach (GridDataItem childItem in detailsTable.Items)

{

totalInvoice += System.Convert.ToDecimal(childItem["Price"].Text);

}

item["TotalInvoice"].Text = String.Format("{0:c}", totalInvoice);

}

Any idea?
Regards
Jose

Accepted

answered on 23 Mar 2011, 07:06 AM

Hello Jose,

Try the following code snippet in PreRender event and check if it works now.

C#:

protected void RadGrid1_PreRender(object sender, EventArgs e)

{

foreach (GridDataItem item in RadGrid1.Items)

{

if (item.Expanded)

{

GridTableView tableView = (GridTableView)item.ChildItem.NestedTableViews[0];

decimal totalInvoice = 0;

foreach (GridDataItem childitem in tableView.Items)

{

totalInvoice += System.Convert.ToDecimal(childItem["Price"].Text);

}

Thanks,
Princy.