title: Telerik RadGrid binding to large DataTable
body: <p>I have successfully gotten a RadGrid to bind to a large DataTable that takes a lengthy query to produce. My problem is that the RadGrid will only show one page, and has to post back when the user changes page, and I lose my DataTable and must do this huge query once again.</p>
  
  <p>I tried to Ajaxify the RadGrid, but it still calls Page_Load so I can't save my DataTable. (is it supposed to do that?) </p>
  
  <p>What can I do differently? Thanks.</p>
  
  <pre><code>    &lt;telerik:RadAjaxManager runat="server"&gt;
              &lt;AjaxSettings&gt;
                  &lt;telerik:AjaxSetting AjaxControlID="rgReport"&gt;
                      &lt;UpdatedControls&gt;
                          &lt;telerik:AjaxUpdatedControl ControlID="rgReport" 
                              LoadingPanelID="RadAjaxLoadingPanel1" /&gt;
                      &lt;/UpdatedControls&gt;
                  &lt;/telerik:AjaxSetting&gt;
              &lt;/AjaxSettings&gt;
          &lt;/telerik:RadAjaxManager&gt;
  
              &lt;telerik:RadScriptManager ID="RadScriptManager1" runat="server"&gt;
          &lt;Scripts&gt;
              &lt;asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.Core.js" /&gt;
              &lt;asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQuery.js" /&gt;
          &lt;/Scripts&gt;
      &lt;/telerik:RadScriptManager&gt;
                  &lt;telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" IsSticky="False" Style="position: absolute; top: 0px; left: 0px; width: 100%; height: 100%;"  EnableSkinTransparency="true" Transparency="0"&gt;
  &lt;/telerik:RadAjaxLoadingPanel&gt;
  
   &lt;telerik:RadGrid ID="rgReport" runat="server" AllowPaging="True" PageSize="50" 
                      AllowSorting="True" OnNeedDataSource="rgReport_NeedsDataSource" OnItemCommand="rgReport_ItemCommand"
                      AutoGenerateColumns="False" ShowStatusBar="True" CellSpacing="0" 
                      GridLines="None"&gt;
                      &lt;ClientSettings&gt;
                          &lt;ClientEvents OnRowMouseOver="CBGridRowMouseOver" OnRowMouseOut="CBGridRowMouseOut" /&gt; 
                      &lt;/ClientSettings&gt;
                      &lt;MasterTableView Width="100%" DataKeyNames="submissionID"  Name="Master"&gt;
                          &lt;CommandItemSettings ExportToPdfText="Export to Pdf"&gt;&lt;/CommandItemSettings&gt;
                          &lt;RowIndicatorColumn FilterControlAltText="Filter RowIndicator column" 
                              Visible="True"&gt;
                          &lt;/RowIndicatorColumn&gt;
                          &lt;ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column" 
                              Visible="True"&gt;
                          &lt;/ExpandCollapseColumn&gt;
                          &lt;Columns&gt;
                              &lt;telerik:GridBoundColumn SortExpression="customerID" HeaderText="customerID" HeaderButtonType="None" 
                                  DataField="customerID"&gt;
                              &lt;/telerik:GridBoundColumn&gt;
  </code></pre>