or
<%@ Page Language="C#" AutoEventWireup="True" Inherits="Litho.MP.Web.Base.UI.ShoppingCart" Codebehind="ShoppingCart.aspx.cs" %><%@ Register Src="AddressControl.ascx" TagName="AddressControl" TagPrefix="uc2" %><%@ Register Src="ShoppingCartItemList.ascx" TagName="ShoppingCartItemList" TagPrefix="uc1" %><%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %><asp:Content ID="Content1" ContentPlaceHolderID="mainContent" runat="Server"><style type="text/css"> .buttons { display:none; } .radButton { display:block; } </style> <h1><asp:Literal ID="ltrShoppingCart" runat="server" Text="Varukorg"/></h1> <div id="content"> <asp:MultiView ID="mvMain" runat="server"> <asp:View ID="viewEmptyCart" runat="server"> <asp:Label ID="lblShoppingCartIsEmpty" runat="server" Font-Bold="true" Text="Varukorgen är tom" /> </asp:View> <asp:View ID="viewEditCart" runat="server"> <h2><asp:Literal ID="ltrStepOneOfFour" runat="server" Text="Steg 1 av 3" /></h2> <p><asp:Label ID="lblChooseAmountAndProceed" runat="server" Text="Välj det antal du vill ha av varje vara och klicka sedan på nästa för att fortsätta" /></p> <asp:Panel ID="pnlHelpText" runat="server"> <div style="float:left;padding-bottom:15px;"> <asp:Label ID="lblHelpText" CssClass="lblHelpText" runat="server" /> </div> <div style="clear:both;"></div> </asp:Panel> <br /> <uc1:ShoppingCartItemList id="ShoppingCartItemList1" Editable="true" OnShoppingCartItemDeleted="ShoppingCartItemList1_ShoppingCartItemDeleted" runat="server" /> <br /> <br /> <div style="clear:both;"></div> <div style="float:left;width:300px;"> <div style="float:left;"> <div class="buttons"> <asp:Button ID="btnClearShoppingCart" runat="server" CssClass="btn btnClearShoppingCart" Text="Töm varukorgen" OnClick="btnClearShoppingCart_Click" /> </div> <div class="radButton"> <telerik:RadButton ID="btnClearShoppingCartRadbutton" Text="Töm varukorgen" runat="server" OnClick="btnClearShoppingCart_Click"> <Icon PrimaryIconCssClass="rbRemove" PrimaryIconLeft="4" PrimaryIconTop="4" /> </telerik:RadButton> </div> </div> <div style="float:left;padding-left:5px;"> <asp:Panel ID="pnlContinueShopping" runat="server"> <div class="buttons"> <asp:Button ID="btnContinueShopping" runat="server" CssClass="btn btnContinueShopping" Text="Beställ mer" OnClick="btnContinueShopping_Click" /> </div> <div class="radButton"> <telerik:RadButton ID="btnContinueShoppingRadbutton" Text="Beställ mer" runat="server" OnClick="btnContinueShopping_Click" /> </div> </asp:Panel> </div> <div style="float:left;padding-left:5px;"> <div class="buttons"> <asp:Button ID="btnStep1Next2" runat="server" CssClass="btn btnStep1Next btnNext" Text="Nästa" OnClick="btnStep1Next_Click" /> </div> <div class="radButton"> <telerik:RadButton ID="btnStep1Next2RadButton" Text="Nästa" runat="server" OnClick="btnStep1Next_Click"> <Icon SecondaryIconCssClass="rbNext" SecondaryIconRight="4" SecondaryIconTop="5" /> </telerik:RadButton> </div> </div> </div> </asp:View> <asp:View ID="viewAddresses" runat="server"> <h2><asp:Literal ID="ltrStepTwoOfFour" runat="server" Text="Steg 2 av 3" /></h2> <p><asp:Label ID="lblEnterAddressesAndContinue" runat="server" Text="Fyll i leveransadress och fakturaadress och klicka sedan på nästa för att fortsätta" /></p> <br /> <table> <tr> <td class="tdAddress"> <uc2:AddressControl id="ucDeliveryAddressControl" runat="server" /> </td> <td class="tdAddress"> <uc2:AddressControl id="ucInvoiceAddressControl" runat="server" /> </td> </tr> <asp:Panel ID="pnlCopyDeliveryAddress" runat="server"> <tr> <td colspan="2"> <div class="buttons"><asp:Button ID="btnCopyDeliveryAddress" runat="server" Text="Kopiera address ->" CssClass="btn btnCopyDeliveryAddress" OnClick="btnCopyDeliveryAddress_Click" /></div> <div class="radButton"> <telerik:RadButton ID="btnCopyDeliveryAddressRadbutton" Text="Kopiera address ->" runat="server" OnClick="btnCopyDeliveryAddress_Click" /> </div> <br /> <br /> </td> </tr> </asp:Panel> <asp:Panel ID="pnlOrganisationNumber" runat="server"> <tr> <td> <asp:Label ID="lblOrganisationNumber" runat="server" /> <asp:RequiredFieldValidator ID="reqOrganisationNumber" runat="server" ControlToValidate="tbOrganisationNumber" ValidationGroup="vgAddress" Enabled="false"/> <br /> <telerik:RadTextBox ID="tbOrganisationNumber" runat="server" CssClass="AddressTextBox" /> <br /> </td> </tr> </asp:Panel> <asp:Panel ID="pnlDocumentNumber" runat="server"> <tr> <td> <div style="margin-left:5px"> <asp:Label ID="lblDocumentNumber" runat="server" /> <asp:RequiredFieldValidator ID="reqDocumentNumber" runat="server" ControlToValidate="tbDocumentNumber" ValidationGroup="vgAddress" Enabled="false"/> <br /> <telerik:RadTextBox ID="tbDocumentNumber" runat="server" CssClass="AddressTextBox" Width="200px" /> </div> <br /> </td> </tr> </asp:Panel> <tr> <td colspan="2"> <div style="margin-left:5px"> <asp:Label ID="lblMessage" runat="server" Text="Meddelande" /><br /> <telerik:RadTextBox ID="tbMessage" runat="server" CssClass="AddressTextBox" TextMode="MultiLine" Width="200px"/> </div> <br /> </td> </tr> </table> <br /> <div style="float:left;margin-left:6px;"> <div class="buttons"> <asp:Button ID="btnStep2Prev2" runat="server" CssClass="btn btnStep2Prev btnPrev" Text="Föregående" OnClick="btnStep2Prev_Click" /> </div> <div class="radButton"> <telerik:RadButton ID="btnStep2Prev2RadButton" Text="Föregående" runat="server" OnClick="btnStep2Prev_Click"> <Icon PrimaryIconCssClass="rbPrevious" PrimaryIconLeft="4" PrimaryIconTop="5" /> </telerik:RadButton> </div> </div> <div style="float:left;padding-left:5px;"> <div class="buttons"> <asp:Button ID="btnStep2Next2" runat="server" ValidationGroup="vgAddress" CssClass="btn btnStep2Next btnNext" Text="Nästa" OnClick="btnStep2Next_Click" /> </div> <div class="radButton"> <telerik:RadButton ID="btnStep2Next2RadButton" ValidationGroup="vgAddress" Text="Nästa" runat="server" OnClick="btnStep2Next_Click"> <Icon SecondaryIconCssClass="rbNext" SecondaryIconRight="4" SecondaryIconTop="5" /> </telerik:RadButton> </div> </div> </asp:View> <asp:View ID="viewReviewAndOrder" runat="server"> <h2><asp:Literal ID="ltrStep3OfFour" runat="server" Text="Steg 3 av 3" /></h2> <p><asp:Label ID="lblReviewAndOrder" runat="server" Text="Kontrollera alla uppgifter och klicka sedan på beställ för att genomföra beställningen" /></p> <br /> <table cellpadding="0" cellspacing="0"> <tr> <td> <uc1:ShoppingCartItemList id="ShoppingCartItemList2" Editable="false" runat="server" /> <br /> <br /> </td> </tr> <tr> <td> <table cellpadding="0" cellspacing="0"> <tr> <td style="vertical-align: top; padding-right: 20px;"> <uc2:AddressControl id="ucDelivery2AddressControl" Mode="0" runat="server" /> </td> <td style="vertical-align: top;"> <uc2:AddressControl id="ucInvoice2AddressControl" Mode="0" runat="server" /> </td> </tr> </table> <br /> </td> </tr> <asp:Panel ID="pnlOrganisationNumberReview" runat="server"> <tr> <td> <asp:Label ID="lblOrganisationNumberReviewHeading" runat="server" Font-Bold="true" Text="Organisationsnummer" /><br /> <asp:Label ID="lblOrganisationNumberReview" runat="server" /> <br /> <br /> </td> </tr> </asp:Panel> <asp:Panel ID="pnlDocumentNumberReview" runat="server"> <tr> <td> <asp:Label ID="lblDocumentNumberReviewHeading" runat="server" Font-Bold="true" Text="CDIID" /><br /> <asp:Label ID="lblDocumentNumberReview" runat="server" /> <br /> <br /> </td> </tr> </asp:Panel> <asp:Panel ID="pnlMessageReview" runat="server"> <tr> <td> <asp:Label ID="lblMessageReviewHeading" runat="server" Font-Bold="true" Text="Meddelande" /><br /> <asp:Label ID="lblMessageReview" runat="server" /> <br /> <br /> </td> </tr> </asp:Panel> <asp:Panel ID="pnlExpressOrder" runat="server"> <tr> <td> <asp:CheckBox ID="cbExpressOrder" runat="server" Text="Expressbeställning" /> <br /> <br /> </td> </tr> </asp:Panel> </table> <br /> <div class="buttons"> <asp:Button ID="btnStep3Prev2" runat="server" Text="Föregående" CssClass="btn btnStep3Prev btnPrev" OnClick="btnStep3Prev_Click" /> </div> <div style="float:left;"> <div class="radButton"> <telerik:RadButton ID="btnStep3Prev2RadButton" Text="Föregående" runat="server" OnClick="btnStep3Prev_Click"> <Icon PrimaryIconCssClass="rbPrevious" PrimaryIconLeft="4" PrimaryIconTop="5" /> </telerik:RadButton> </div> </div> <div class="buttons"> <asp:Button ID="btnStep3Order2" runat="server" Text="Beställ" CssClass="btn btnStep3Order btnOrder" OnClick="btnStep3Order_Click" /> </div> <div style="float:left;padding-left:5px;"> <div class="radButton"> <telerik:RadButton ID="btnStep3Order2RadButton" Text="Beställ" runat="server" OnClick="btnStep3Order_Click" /> </div> </div> </asp:View> <asp:View ID="viewConfirmation" runat="server"> <p><asp:Label ID="lblOrderConfirmation" runat="server" Text="Tack för din beställning!" /></p> </asp:View> <asp:View ID="viewOrderError" runat="server"> <p><asp:Label ID="lblOrderError" runat="server" Text="Beställningen misslyckades. Kontakta support@litho.se för hjälp." /></p> </asp:View> </asp:MultiView> </div> </asp:Content>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; |
| } |
| } |