Export to CSV with Grid is invisible

[FISCAL]

Hello everyone,

I am looking for a solution where by I can export grid data to CSV even when grid is invisible. This is needed for various reasons. Any ideas would be highly appreciated. 

Happy New Year 2011.

Many thanks.
MG

[Princy]

Hello,

Set the visibility of Radgrid as 'true' before exporting and then ExportToCSV like below.

ASPX:

<telerik:RadGrid ID="RadGrid1" runat="server" Visible="false">
    <MasterTableView  runat="server" CommandItemDisplay="Top" >
        <CommandItemSettings ShowExportToCsvButton="true" />
    </MasterTableView>
</telerik:RadGrid>

<asp:Button ID="Button1" runat="server" Text="Export to CSV" OnClick="Button1_Click" />

C#:

protected void Button1_Click(object sender, EventArgs e)
    {
        RadGrid1.Visible = true;
        RadGrid1.ExportSettings.OpenInNewWindow = true;
        RadGrid1.MasterTableView.ExportToCSV();
    }

Thanks,
Princy.