Grid not ignoring Paging on Export

[Kevin]

Never had a problem with this until now and I think it is some extra code I need with C#, just switched over last month and its always worked with VB.  BUt my grid will not ignore paging on export, it only exports the current page.  Is there some extra code behind I need.  I put in the GridExporting and BiffExporting but niether made a difference still only 1 page that gets exported.  So what am I missing?

<telerik:RadGrid ID="myRadGrid" runat="server" Skin="Web20" Width="80%" OnNeedDataSource="myRadGrid_NeedDataSource" CssClass="CentDiv3" OnPageIndexChanged="myRadGrid_PageIndexChanged"
       OnPageSizeChanged="myRadGrid_PageSizeChanged" OnSortCommand="myRadGrid_SortCommand" OnGridExporting="myRadGrid_GridExporting" OnBiffExporting="myRadGrid_BiffExporting">
       <ExportSettings ExportOnlyData="true" Excel-Format="Biff" IgnorePaging="true" OpenInNewWindow="true"></ExportSettings>
       <MasterTableView runat="server" AutoGenerateColumns="false" Font-Size="9" AllowPaging="true" AllowSorting="true" CommandItemDisplay="Top">



protected void myRadGrid_PageIndexChanged(object sender, GridPageChangedEventArgs e)
   {
       fillGrid = true;
       myRadGrid.Rebind();
   }
   protected void myRadGrid_PageSizeChanged(object sender, GridPageSizeChangedEventArgs e)
   {
       fillGrid = true;
       myRadGrid.Rebind();
   }
   protected void myRadGrid_SortCommand(object sender, GridSortCommandEventArgs e)
   {
       fillGrid = true;
       myRadGrid.Rebind();
   }
   protected void myRadGrid_GridExporting(object sender, GridExportingArgs e)
   {
       fillGrid = true;
       myRadGrid.Rebind();
   }
   protected void myRadGrid_BiffExporting(object sender, GridBiffExportingEventArgs e)
   {
       fillGrid = true;
       myRadGrid.Rebind();
   }

[Princy]

Hi Kevin,

When using Advanced Data-binding (using NeedDataSource event), you don't have to manually do any operations for paging, sorting, filtering etc. Take a look at the sample code snippet which Export's to Excel without paging. Please try and let me know if any concern.

ASPX:

<telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="true" AllowPaging="true"   OnNeedDataSource="RadGrid1_NeedDataSource" PageSize="5">
    <ExportSettings ExportOnlyData="true" Excel-Format="Biff" IgnorePaging="true" OpenInNewWindow="true">
    </ExportSettings>
    <MasterTableView CommandItemDisplay="Top" CommandItemSettings-ShowExportToExcelButton="true">
    </MasterTableView>
</telerik:RadGrid>

C#:

protected void RadGrid1_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
{
 dynamic data = new[] {
new { ID = 1, Name = "Name1", Number=123},
new { ID = 2, Name = "Name2", Number=234},
new { ID = 3, Name = "Name3", Number=234},
new { ID = 4, Name = "Name4", Number=456},
new { ID = 5, Name = "Name5", Number=567},
new { ID = 6, Name = "Name6", Number=567},
new { ID = 7, Name = "Name7", Number=789},
new { ID = 8, Name = "Name8", Number=896},
new { ID = 9, Name = "Name9", Number=741}
};
 RadGrid1.DataSource = data;
}

Thanks,
Princy