Hi
I am trying to export data in the RadGridView to Excel i am using
EntityQueryPagedCollectionView from devforce as the data source to the grid through RadDataPager.
when i am trying to export it is only exporting the current page .
I set the page size of DataSource to zero instead of the datapager .
I think i am missing something here can anyone please help me .
Thanks!
Vijay
I am trying to export data in the RadGridView to Excel i am using
EntityQueryPagedCollectionView from devforce as the data source to the grid through RadDataPager.
when i am trying to export it is only exporting the current page .
using (var fileStream = dialog.OpenFile())
{
DataSource.PageSize = 0;
var exportOptions = new GridViewExportOptions
{
Format = ExportFormat.ExcelML,
ShowColumnFooters = false,
ShowColumnHeaders = true,
ShowGroupFooters = false,
Items = (IEnumerable)_dataPager.PagedSource
};
_gridView.Export(fileStream, exportOptions);
}
DataSource.PageSize = originalPageSize;
_dataPager.PageSize = originalPageSize;
_dataPager.PageIndex = originalPageIndex;
public EntityQueryPagedCollectionView DataSource
{
get { return _dataSource; }
set { _dataSource = value; NotifyOfPropertyChange(() => DataSource); }
}
I set the page size of DataSource to zero instead of the datapager .
I think i am missing something here can anyone please help me .
Thanks!
Vijay