我如何能够在问题'System.Outofmemoryexception'来自使用中继控制？总记录大小50,000 [英] How Can I Over Come From The Problem 'System.Outofmemoryexception' While Using Repeater Control? Total Records Size 50,000

问题描述

< asp：Repeater ID =Repeater1runat =server>

< HeaderTemplate>

width =100％>

< / HeaderTemplate>

< itemtemplate>

<％ - - ％>

<％----％>

<％ -



- ％>



<％ - < footertemplate>

< th align =leftstyle =background-color：＃fce9db; width：5％><％ - < label id =uilblVCNfor =ui_lblGVCN>

VCN< / label> - ％>

< label id =lblPatientIdfor =ui_lblGVCN>

PatientId< / label>

< label id =Label16for =ui_lblreqID> Sno< / label>	< label id =lblPrnofor =ui_lblreqID> MR No.< / label>	<％ - < label id =uilblRCNfor =ui_lblRCN> RCN< / label> - ％> < label id =lblpatienttypefor =ui_lblRCN> 患者类型< / label>	< label id =lblDisgStatusfor =ui_lblStatus> Disg Status< / label>	< label id =lblRegDatefor =ui_lblOperation> 注册日期< / label>	< label id =lblAdmsDatefor =ui_lblEquipmentName> IPAdmission Date< / label>	<％ - < label id =uilblCommodityfor =ui_lblDriverName> Commodity< / label> - ％> < label id =lblOpConslDatefor =ui_lblDriverName> OpConsultation Date< / label>	<％ - < label id =uilblTotalQtyfor =ui_lblRequestedby> 总数量< / label> - ％> < label id =lblPatientNamefor =ui_lblRequestedby> 名称< / label>	<％ - left< label id =uilblExceptLoadQtyfor =ui_lblStatus> 除了/加载数量< / label> - ％> < label id =lblAgefor =ui_lblStatus> 年龄< / label>	<％ - < label id =uilblDiscLoadQtyfor =ui_lblRequestedDate> Disc / Load Qty< / label> - ％> < label id =lblGenderfor =ui_lblStatus> 性别< / label>	< label id =lblStreetfor =ui_lblStatus> Street< / label>	< label id =Label1for =ui_lblStatus> PhoneR< / label>	< label id =Label2for =ui_lblStatus> City< / label>	< label id =Label3for =ui_lblStatus> State< / label>	< label id =Label4for =ui_lblStatus> 国家< / label>	< label id =Label5for =ui_lblStatus> 电子邮件< / label>	< label id =lblOrgfor =ui_lblStatus> 公司< / label>	< label id =lblPaytypefor =ui_lblStatus> PayType< / label>	< label id =Label11for =ui_lblStatus> 保险< / label>
< asp：Label ID =lblsnorunat =serverText ='<％#Container.ItemIndex + 1％>'> ;	< asp：Label ID =lbleqpdtl_idrunat =serverVisible =falseText ='<％＃DataBinder。 Eval（Container.DataItem，MR No）％>'> < asp：Label ID =lblreqcodeStyle =display：nonerunat =serverText =' <％＃DataBinder的.Eval（Container.DataItem，MR No）％>'> < asp：LinkBut​​ton ID =lnkReqCoderunat =serverText ='<％＃DataBinder。 Eval（Container.DataItem，MR No）％>'>	< asp：Label ID =lblDaterunat = serverText ='<％＃DataBinder.Eval（Container.DataItem，PatientId）％>'>	< asp ：Label ID =lblEquipNorunat =serverText ='<％＃DataBinder.Eval（Container.DataItem，Patient Type）％>'>	< asp：Label ID =Label10runat =serverText ='<％＃DataBinder.Eva l（Container.DataItem，Disg Status）％>'>	< asp：Label ID =lblFuelTyperunat = serverText ='<％＃DataBinder.Eval（Container.DataItem，Registered Date）％>'>	< asp：Label ID =Label7runat =serverText ='<％＃DataBinder.Eval（Container.DataItem，IPAdmissionDate）％>'>	< asp：Label ID =Label8runat =serverText ='<％＃DataBinder.Eval（Container.DataItem，OpConsultationDate）％>'>	< asp：Label ID =Label9runat =serverText ='<％＃DataBinder.Eval（Container.DataItem，Patient Name）％>'>	< asp：Label ID =lblQuantityrunat =serverText ='<％＃DataBinder.Eval（Container.DataItem，Age）％> ;'>	< asp：Label ID =lblRequestedDaterunat =serverText ='<％＃DataBinder.Eval（ Container.DataItem，Gender）％>'>	< asp：Label ID =Label10 runat =serverText ='<％＃DataBinder.Eval（Container.DataItem，House No）％>'>	< asp：Label ID =Label11runat =serverText ='<％＃DataBinder.Eval（Container.DataItem，位置）％>'>	< asp：标签ID =lblPRIORITYrunat =serverText ='<％ #DataBinder.Eval（Container.DataItem，Address）％>'>	< asp：Label ID =Label6runat =serverText ='<％＃DataBinder.Eval（Container.DataItem，PhoneR）％>'>	< ; asp：Label ID =Label12runat =serverText ='<％＃DataBinder.Eval（ Container.DataItem，City）％>'>	< asp：Label ID =Label13runat =serverText ='<％＃DataBinder.Eval（Container.DataItem，State）％>'>	< asp：标签ID =Label14runat =serverText ='<％＃DataBinder.Eval（Container.DataItem，Country）％>'>	< asp：Label ID =Label15runat =serverText ='<％＃DataBinder.Eval（Container.DataItem，Email）％>'>	< asp：Label ID =Label17runat =serverText ='<％＃DataBinder.Eval（Container.DataItem，Company）％>'>	< asp：Label ID =Label18runat =serverText ='<％＃DataBinder.Eval（Container.DataItem，PayType）％>'>	< asp：Label ID =Label19runat =serverText ='<％＃DataBinder.Eval（Container.DataItem， 保险）％>'>	< asp：Label ID =Label19runat = serverText ='<％＃DataBinder.Eval（Container.DataItem，Insurance）％>'>	< asp：Label ID =Label20runat =serverText ='<％＃DataBinder.Eval（Container.DataItem，Arogya Sree）％>'>

- ％>

<asp:Repeater ID="Repeater1" runat="server">
<HeaderTemplate>

width="100%">
</HeaderTemplate>
<itemtemplate>
<%-- --%>
<%----%>
<%--

--%>

<%--<footertemplate>

<label id="Label16" for="ui_lblreqID"> Sno</label>	<label id="lblPrno" for="ui_lblreqID"> MR No.</label>	<%-- <label id="uilblVCN" for="ui_lblGVCN"> VCN</label>--%> <label id="lblPatientId" for="ui_lblGVCN"> PatientId</label>	<%-- <label id="uilblRCN" for="ui_lblRCN"> RCN</label>--%> <label id="lblpatienttype" for="ui_lblRCN"> Patient's Type</label>	<label id="lblDisgStatus" for="ui_lblStatus"> Disg Status</label>	<label id="lblRegDate" for="ui_lblOperation"> Registered Date</label>	<label id="lblAdmsDate" for="ui_lblEquipmentName"> IPAdmission Date</label>	<%--<label id="uilblCommodity" for="ui_lblDriverName"> Commodity</label>--%> <label id="lblOpConslDate" for="ui_lblDriverName"> OpConsultation Date</label>	<%-- <label id="uilblTotalQty" for="ui_lblRequestedby"> Total Qty</label>--%> <label id="lblPatientName" for="ui_lblRequestedby"> Name</label>	<%--left<label id="uilblExceptLoadQty" for="ui_lblStatus"> Except/Load Qty</label>--%> <label id="lblAge" for="ui_lblStatus"> Age </label>	<%-- <label id="uilblDiscLoadQty" for="ui_lblRequestedDate"> Disc/Load Qty</label>--%> <label id="lblGender" for="ui_lblStatus"> Gender</label>	<label id="lblStreet" for="ui_lblStatus"> Street</label>	<label id="Label1" for="ui_lblStatus"> PhoneR</label>	<label id="Label2" for="ui_lblStatus"> City</label>	<label id="Label3" for="ui_lblStatus"> State</label>	<label id="Label4" for="ui_lblStatus"> Country</label>	<label id="Label5" for="ui_lblStatus"> Email</label>	<label id="lblOrg" for="ui_lblStatus"> Company</label>	<label id="lblPaytype" for="ui_lblStatus"> PayType</label>	<label id="Label11" for="ui_lblStatus"> Insurance</label>
<asp:Label ID="lblsno" runat="server" Text='<%#Container.ItemIndex+1 %>'>	<asp:Label ID="lbleqpdtl_id" runat="server" Visible="false" Text='<%#DataBinder.Eval(Container.DataItem,"MR No")%>'> <asp:Label ID="lblreqcode" Style="display: none" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"MR No")%>'> <asp:LinkButton ID="lnkReqCode" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"MR No")%>'>	<asp:Label ID="lblDate" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"PatientId")%>'>	<asp:Label ID="lblEquipNo" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"Patient Type")%>'>	<asp:Label ID="Label10" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"Disg Status")%>'>	<asp:Label ID="lblFuelType" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"Registered Date")%>'>	<asp:Label ID="Label7" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"IPAdmissionDate")%>'>	<asp:Label ID="Label8" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"OpConsultationDate")%>'>	<asp:Label ID="Label9" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"Patient Name")%>'>	<asp:Label ID="lblQuantity" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"Age")%>'>	<asp:Label ID="lblRequestedDate" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"Gender")%>'>	<asp:Label ID="Label10" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"House No")%>'>	<asp:Label ID="Label11" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"Location")%>'>	<asp:Label ID="lblPRIORITY" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"Address")%>'>	<asp:Label ID="Label6" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"PhoneR")%>'>	<asp:Label ID="Label12" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"City")%>'>	<asp:Label ID="Label13" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"State")%>'>	<asp:Label ID="Label14" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"Country")%>'>	<asp:Label ID="Label15" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"Email")%>'>	<asp:Label ID="Label17" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"Company")%>'>	<asp:Label ID="Label18" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"PayType")%>'>	<asp:Label ID="Label19" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"Insurance")%>'>	<asp:Label ID="Label19" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"Insurance")%>'>	<asp:Label ID="Label20" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"Arogya Sree")%>'>

--%>

推荐答案

不要这样做。

想一想。

单个转发器中的50,000条记录？

您想坐在那里等待该网页吗？

试图通过滚动1,000到2,000页的行来查找他要查找的信息？


因为我不愿意，我也不会回到你的网站......



查找更好的用户界面来显示这一点 - 想想你的用户并尝试设计一个探测者想要使用的网站，而不是讨厌！

Don't do that.
Think about it.
50,000 records in a single repeater?
Would you like to be the user sitting there waiting for that webpage?
Trying to find the information he is looking for by scrolling through 1,000 to 2,000 pages of rows?

Because I wouldn't, and I wouldn't be back to your site...

Find a better user interface to display this - think about your users and try to design a site that soundings will want to use, not hate!

这篇关于我如何能够在问题'System.Outofmemoryexception'来自使用中继控制？总记录大小50,000的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！