[Solved] Export to Exl

[Vijay]

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 .

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

[Vlad]

Hello Vijay,

 You need to download all the data if you want to export all pages - similar demo can be found here:
http://demos.telerik.com/silverlight/#GridView/ExportingPagedData

All the best,
Vlad
the Telerik team