This is a migrated thread and some comments may be shown as answers.

Index was outside the bounds of the array.

1 Answer 297 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
bharat veer
Top achievements
Rank 1
bharat veer asked on 21 Mar 2011, 12:56 PM
My data is being shown in RadGrid. i am trying to export data in Excel. Properties are set for the RadGrid
like
        rdGridCustomer.ExportSettings.FileName = "MyDataFile";
        rdGridCustomer.ExportSettings.ExportOnlyData = true;
        rdGridCustomer.ExportSettings.IgnorePaging = false ;
        rdGridCustomer.ExportSettings.OpenInNewWindow = true;
        rdGridCustomer.ExportSettings.Excel.FileExtension = "xls";
        rdGridCustomer.ExportSettings.Excel.Format = Telerik.Web.UI.GridExcelExportFormat.Html;

event on that Excel is being exported.
 protected void btnExport_Click(object sender, EventArgs e)
    {
       
        rdGridCustomer.MasterTableView.ExportToExcel();     
    }
   event of Radgrid that is generated error
   Index was outside the bounds of the array.
when below event is fired after btnExport_Click event error occurs. It occurs only when
rdGridCustomer.MasterTableView.ExportToExcel();     this code of line exceuted.
 protected void rgModuleGrid_PreRender(object sender, EventArgs e)
      {
          // Institute Maximum Page Size for Main Grid
          GridPagerItem pagerItem = (GridPagerItem)rdGridCustomer.MasterTableView.GetItems(GridItemType.Pager)[1];
          on this above bold line error occures.
          RadNumericTextBox textBox = (RadNumericTextBox)pagerItem.FindControl("ChangePageSizeTextBox");
       }
please give me solution.
Thanks.

1 Answer, 1 is accepted

Sort by
0
Princy
Top achievements
Rank 2
answered on 22 Mar 2011, 05:22 AM
Hello Bharat,

Try the following approach (setting flag when grid is exporting) and check whether it resolves the error.

C#:
bool flag = false;
 protected void btnExport_Click(object sender, EventArgs e)
 {
     rdGridCustomer.MasterTableView.ExportToExcel();
     flag = true;
 }
 protected void rdGridCustomer_PreRender(object sender, EventArgs e)
 {
     if (!flag)
     {
        GridPagerItem pagerItem = (GridPagerItem)rdGridCustomer.MasterTableView.GetItems(GridItemType.Pager)[0];
     }
     else
         flag = false;
 }

Thanks,
Princy.
Tags
General Discussions
Asked by
bharat veer
Top achievements
Rank 1
Answers by
Princy
Top achievements
Rank 2
Share this question
or