Exporting the all data when using virtualitemcount

[Bharat]

I am showing details for a single page at a time, but i need to export all records

Please suggest on this.

Thanks & Regards
Bharat

[Princy]

Hi Bharat,

When setting VirtualItemCount property of the RadGrid, you need to set the PageSize to this property during the Export to have all the pages Exported.

C#:

protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
 if (e.CommandName == RadGrid.ExportToExcelCommandName)
  {
    RadGrid1.PageSize = RadGrid1.MasterTableView.VirtualItemCount;
    RadGrid1.ExportSettings.ExportOnlyData = true;
    RadGrid1.ExportSettings.IgnorePaging = true;
    RadGrid1.ExportSettings.OpenInNewWindow = true;
  }
}

Thanks,
Princy