欢迎来到天天文库
浏览记录
ID:9479658
大小:76.50 KB
页数:10页
时间:2018-05-01
《asp.net(c#)海量数据表高效率分页算法--》由会员上传分享,免费在线阅读,更多相关内容在应用文档-天天文库。
1、asp.net(C#)海量数据表高效率分页算法>>首先创建一张表(要求ID自动编号):createtableredheadedfile(idintidentity(1,1),filenamesnvarchar(20),sendusernvarchar(20),primarykey(id))然后我们写入50万条记录:declareiintseti=1es,senduser)values('我的分页算法','陆俊铭')seti=i+1endGO用MicrosoftVisualStudio.2003创建一张LPUBLIC"-//L4.0Transitional//EN">
2、;<HTML><HEAD><title>icrosoftVisualStudio.7.1"name="GENERATOR"><metacontent="C#"name="CODE_LANGUAGE"><metacontent="JavaScript"name="vs_defaultClientScript"><metacontent="intellisense/ie5"name="vs_targetSchema"></HEAD><bodyMS_POSITIONING="Gri
3、dLayout"><formid="Form1"method="post"runat="server"><asp:datalistid="datalist1"AlternatingItemStyle-BackColor="#f3f3f3"Template><table,"filenames")%></td><td,"senduser")%></td><td,"id")%></td></tr></table></ItemTemplate>
4、;</asp:datalist><divalign="center">共<asp:labelid="LPageCount"Runat="server"ForeColor="#ff0000"></asp:label>页/共<asp:labelid="LRecordCount"Runat="server"ForeColor="#ff0000"></asp:label>记录<asp:linkbuttonid="Fistpage"Runat="server"mandName="0">首页<
5、/asp:linkbutton>nbsp;nbsp;nbsp;nbsp;<asp:linkbuttonid="Prevpage"Runat="server"mandName="prev">上一页</asp:linkbutton>nbsp;nbsp;nbsp;nbsp;<asp:linkbuttonid="Nextpage"Runat="server"mandName12345下一页>>>>这篇文章来自..,。="next">下一页</asp:linkbutton>nbsp;nbsp;nbsp;nbsp;<asp
6、:linkbuttonid="Lastpage"Runat="server"mandName="last">尾页</asp:linkbutton>nbsp;nbsp;nbsp;nbsp;当前第<asp:labelid="LCurrentPage"Runat="server"ForeColor="#ff0000"></asp:label>页nbsp;nbsp;nbsp;nbsp;跳页<asp:TextBoxID="gotoPage"Runat="server"axLength="5"AutoPostBack="True"&g
7、t;</asp:TextBox></div></form></body></HTML>后台代码片段如下(8.aspx.cs)usingSystem;usingSystem.Collections;usingSystem.ponentModel;usingSystem.Data;usingSystem.Dra.....lControls;usingSystem.Data.SqlClient;usingSystem.Configuration;namespacemary>///
此文档下载收益归作者所有