RAD GRID Export to Excel

[Chakravarthi]

Hi All,

 

We are using Rad Grid control and paging. While Exporting to Excel, only the page 1 records are exporting in to Excel.

Can some one advise on how i can add both Paging and Export to Excel with out using Need Data source.

Thanks

[Eyup]

Hi Chakravarthi,

Try using the following property and let me know if it works for you:

<ExportSettings IgnorePaging="true">

Regards,
Eyup
Telerik

[Shweta]

not worked for me ignorepaging=true

[Eyup]

Hello Shweta,

Please make sure that you are not using DataBind() to bind the grid. Performing complex grid operations such as Inserting, Deleting, Updating, Hierarchy relations, Grouping, Exporting, Paging, Sorting, Filtering, etc. require accommodating appropriate database operations.  Therefore, we suggest you to avoid Simple Databinding and strongly recommend the use of more advanced databinding methods, which automatically handle the aforementioned functions:

Declarative DataSource (DataSourceID property)
Programmatic Data Binding (NeedDataSource event, + DetailTableDataBind for hierarchy). You should set the DataSource property only within these event handlers.

This should resolve the issue.

Regards,
Eyup
Telerik