RadGrid using Webservice binding but not export data...

[nanthakumar thangavel]

RadGrid using Webservice binding but not export data.(Xls,csv)

[Daniel]

Hello Nanthakumar,

Please make sure that you consume the webservice on the server and not on the client.

Regards,
Daniel
the Telerik team

[nanthakumar thangavel]

Hi

I implemented  Grid / Client-side Binding and Caching  concept  because performance Issue for other Databinding Concept.But Exporting not Working 
or any other method  to implement Caching ,Performance with Export Data?

This is my code

<telerik:RadGrid ID="RadGrid2" AllowSorting="true" AllowPaging="true" AllowFilteringByColumn="true"
            AutoGenerateColumns="false" runat="server">
            <MasterTableView CommandItemDisplay="Top">
                <CommandItemSettings ShowExportToCsvButton="True"
                    ShowExportToExcelButton="True" />
                <Columns>
                    <telerik:GridBoundColumn DataField="Id" HeaderText="Id" />
                    <telerik:GridBoundColumn DataField="Name" HeaderText="Name" />

                </Columns>

<PagerStyle AlwaysVisible="True"></PagerStyle>
            </MasterTableView>
            <PagerStyle AlwaysVisible="true" />
            <ClientSettings>
                <DataBinding Location="~/mywebservice.asmx"  EnableCaching="true"
                    SelectMethod="GetFacilityListCH"  />
            </ClientSettings>
        </telerik:RadGrid>

[Daniel]

Hello Nanthakumar,

You have to bind RadGrid on the server only when exporting. Try this approach:

<asp:Button ID="Button1" runat="server" Text="Export" OnClick="Button1_Click" />
<telerik:RadGrid  ID="RadGrid2" AllowSorting="true"  AllowPaging="true"
     ...
     <ClientSettings>
         <DataBinding Location="~/mywebservice.asmx"  EnableCaching="true"
             SelectMethod="GetFacilityListCH"  />
     </ClientSettings>
</telerik:RadGrid>

protected void Button1_Click(object sender, EventArgs e)
{
    RadGrid1.DataSource = MyWebService.GetData();
    RadGrid1.Rebind();
    RadGrid1.MasterTableView.ExportToCSV();
}

Regards,
Daniel
the Telerik team

[nanthakumar thangavel]

Thank you very nice...This very useful for me...