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

[nanthakumar thangavel]

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


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>

[Nikolay Rusev]

Hello Nanthakumar,

You need server binding to export RadGrid. When bound on client RadGrid does not persist data that will be used when export on server.

Greetings,
Nikolay
the Telerik team

[nanthakumar thangavel]

Hi

Thanks for reply ..

i bind server side but i face performance issue. so that i want to improve 
performance and also export
i use cache concept  or any other method to improve performance ?

[Nikolay Rusev]

Hello Nanthakumar,

Export is server-side functionality, thus it need to be performed on server-side.
You can check the following articles for hints on performance:
http://www.telerik.com/help/aspnet-ajax/grdsavinggridviewstateinsession.html
http://www.telerik.com/help/aspnet-ajax/grdviewstateoptimization.html
http://www.telerik.com/help/aspnet-ajax/grdviewstatereductiontechniques.html

Best wishes,
Nikolay
the Telerik team

[nanthakumar thangavel]

Thank you very much.