Sum Columns Grid

[Hector Hernandez]

Hello.

I have this issue i have grid that i modify data with the event ItemDataBound how can i get the sum and put in the footer of the grid of thes columns, since i dont populate this columns with NeedDataSource

Thanks in advence

[Jayesh Goyani]

Hello,

Please try with the below code snippet.

foreach (GridFooterItem footeritem in RadGrid1.MasterTableView.GetItems(GridItemType.Footer))
{
    //Access TemplateColumn's Control
    TextBox textbox = (TextBox)footeritem.FindControl("YourTextBoxID");

    //Access bound column
    footeritem["YOurColumnUNiqueName"].Text = "Your Value";
}

//OR

GridFooterItem footeritem =  (GridFooterItem)RadGrid1.MasterTableView.GetItems(GridItemType.Footer)[0];
if(GridFooterItem != null)
{
    //Access TemplateColumn's Control
    TextBox textbox = (TextBox)footeritem.FindControl("YourTextBoxID");

    //Access bound column
    footeritem["YOurColumnUNiqueName"].Text = "Your Value";
}

Let me know if any concern.

Thanks,
Jayesh Goyani

[Jayesh Goyani]

Hello,

You can write above code snippet in either in page_Prerender event or in Radgrid_Prerender event.

Thanks,
Jayesh Goyani

[Shinu]

Hi Hector Hernandez,

You can set the sum of a column at footer text in the ItemDataBound event as follows:

ASPX:

<telerik:RadGrid ID="RadGrid1" runat="server" OnItemDataBound="RadGrid1_ItemDataBound" ShowFooter="true" >

C#:

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
{
    int total = 0;
    if (e.Item is GridDataItem)
    {
        GridDataItem dataItem = (GridDataItem)e.Item;
        int fieldValue = int.Parse(dataItem["ColumnUniqueName"].Text);
        total = total + fieldValue;
    }
    if (e.Item is GridFooterItem)
    {
        GridFooterItem footerItem = (GridFooterItem)e.Item;
        footerItem["ColumnUniqueName"].Text = "Total: " + total.ToString();
    }
}

Thanks,
Shinu

[Hector Hernandez]

Thank you Jayesh
Work great.

[Hector Hernandez]

Thank you Shinu!!
Wonderfull!!