Can't export to Excel...

[Ramy Mahrous]

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
{
if (e.Item is GridDataItem)
{
GridDataItem dataItem = (GridDataItem)e.Item;
rev1Sum += CorrectlyParseString((dataItem["Rev1"].FindControl("Rev1Label") as Label).Text.ToString());
}
else if (e.Item is GridFooterItem)
{
GridFooterItem footer = (GridFooterItem)e.Item;
(footer["Rev1"].FindControl("Rev1Total") as RadNumericTextBox).Value = Double.Parse(rev1Sum.ToString());
}
}

when I'm exporting to Excel, it gives me Object reference not set to an instance of an object
Rev1 is GridTemplateColumn

[Daniel]

Hello Ramy,

You have to check whether the FindControl method has found the control or it has been removed when exporting. Sample code:

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
{
    if (e.Item is GridDataItem)
    {
        GridDataItem dataItem = (GridDataItem)e.Item;
        Label lblRev1 = dataItem["Rev1"].FindControl("Rev1Label") as Label;
        if(lblRev1 != null)
            rev1Sum += CorrectlyParseString(lblRev1.Text);
    }
    else if (e.Item is GridFooterItem)
    {
        GridFooterItem footer = (GridFooterItem)e.Item;
        RadNumericTextBox rntbRev1 = footer["Rev1"].FindControl("Rev1Total") as RadNumericTextBox;
        if(rntbRev1 != null)
            rntbRev1.Value = Double.Parse(rev1Sum.ToString());
    }
}

Regards,
Daniel
the Telerik team

[Ramy Mahrous]

Thank you, Daniel so much for your help (Y)