or
I have a table with 5,355,113 records. I want to display them in a grid. I have a test application similar
to this: Link
The description of the example says: "allows you to handle millions of records within a few milliseconds",
but I'm getting the error displayed in the attached image.
What am I doing wrong?. The example linked before should be able to handle 5 million records? or, should
I handle the paging in code behind?
This is my ASPX code (No code behind):
<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="RadGrid1"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="RadGrid1" LoadingPanelID="RadAjaxLoadingPanel1" /> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings></telerik:RadAjaxManager><telerik:RadAjaxLoadingPanel runat="server" ID="RadAjaxLoadingPanel1" /><telerik:RadGrid ID="RadGrid1" runat="server" AllowPaging="True" AutoGenerateColumns="False" PageSize="1" DataSourceID="LinqDataSource1"> <PagerStyle Mode="NextPrevAndNumeric" /> <MasterTableView TableLayout="Fixed"> <Columns> <telerik:GridBoundColumn DataField="ID" HeaderText="ID" UniqueName="ID"> </telerik:GridBoundColumn> </Columns> </MasterTableView></telerik:RadGrid><asp:LinqDataSource ID="LinqDataSource1" runat="server" ContextTypeName="WebApplication1.DAL.DataClassesDataContext" TableName="Cards" OrderBy="ID"></asp:LinqDataSource>
.textHover { text-decoration:underline !important; }<telerik:RadTabrunat ="server"Text ="Dashboard" Value ="Dashboard" Selected ="true" HoveredCssClass="textHover"Font-Names ="Verdana" >Protected Sub lnkVerify_Click(sender As Object, e As EventArgs) Handles lnkVerify.Click Dim returnV As String = "" sql = "exec usp_AnnualSignHR '" & Replace(HFDigSig.Value, "'", "''") & "', '" & HFEDIPI.Value & "'" returnV = getData(sql).Rows(0)(0) If returnV = "0" Then pnlGrid.Visible = False ScriptManager.RegisterClientScriptBlock(Page, GetType(Page), "OpenWindow", "alert('Thank you for signing your annual hand receipt. You will be redirected to your Hand Receipt');", True) Response.Write("<meta HTTP-EQUIV=""refresh"" content=""1;url=~/User/UserHR.aspx"">") Else ScriptManager.RegisterClientScriptBlock(Page, GetType(Page), "OpenWindow", "alert('There has been an problem please contact the help desk.');", True) End If End Sub| protected void RadGridCE_DetailTableDataBind(object source, Telerik.Web.UI.GridDetailTableDataBindEventArgs e) |
| { |
| GridDataItem dataItem = (GridDataItem)e.DetailTableView.ParentItem; |
| if (dataItem["is_series"].Text == "1") |
| { |
| int series_id = int.Parse(dataItem["series_id"].Text); |
| e.DetailTableView.DataSource = (FarranMedia.Classes.OnlineCE.CECourseGetBySeriesID(series_id)).Tables[0]; |
| } |
| else |
| { |
| e.DetailTableView.DataSource = null; |
| } |
| } |