`
java-mans
  • 浏览: 11427289 次
文章分类
社区版块
存档分类
最新评论

aspnetpager实现高效分页

 
阅读更多

今天晚上手痒，写了一下代码。使用aspnetpager这个免费的分页控件。

aspx页面部分代码如下：

Code:
  1. <%@PageLanguage="C#"AutoEventWireup="true"CodeBehind="WebForm1.aspx.cs"Inherits="LearningAspNet.无刷新分页.WebForm1"%>
  3. <%@Registerassembly="AspNetPager"namespace="Wuqi.Webdiyer"tagprefix="webdiyer"%>
  5. <!DOCTYPEhtmlPUBLIC"-//W3C//DTDXHTML1.0Transitional//EN""http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  7. <htmlxmlns="http://www.w3.org/1999/xhtml">
  8. <headrunat="server">
  9. <title>AspNetPager+存储过程完成分页</title>
  10. </head>
  11. <body>
  12. <formid="form1"runat="server">
  13. <div>
  14. <asp:RepeaterID="Repeater1"runat="server"onitemcommand="Repeater1_ItemCommand"
  15. onitemdatabound="Repeater1_ItemDataBound">
  16. <HeaderTemplate><!--头模板-->
  17. <table><tr>
  18. <td>学生编号</td>
  19. <td>学生姓名</td>
  20. <td>学生性别</td>
  21. <tdalign="center">操作</td>
  22. </tr>
  23. </HeaderTemplate>
  24. <ItemTemplate><!--项模板-->
  25. <tr>
  26. <td><%#Eval("sid")%></td>
  27. <td><%#Eval("sname")%></td>
  28. <td><%#Eval("ssex")%></td>
  29. <td><asp:ButtonID="Button1"runat="server"Text="Button"CommandName="btn"CommandArgument='<%#Eval("sid")%>'/>
  30. </td></tr>
  31. </ItemTemplate>
  32. <AlternatingItemTemplate><!--交替行-->
  33. <trstyle="background-color:Aqua">
  34. <td><%#Eval("sid")%></td>
  35. <td><%#Eval("sname")%></td>
  36. <td><%#Eval("ssex")%></td>
  37. <td>
  38. <asp:ButtonID="Button1"runat="server"Text="Button"CommandName="btn"CommandArgument='<%#Eval("sid")%>'/>
  39. </td>
  40. </tr>
  41. </AlternatingItemTemplate>
  42. <FooterTemplate><!--脚模板-->
  43. </table>
  44. </FooterTemplate>
  45. </asp:Repeater>
  46. <asp:LabelID="Label1"runat="server"Text=""></asp:Label>
  47. </div>
  49. <webdiyer:AspNetPagerID="AspNetPager1"runat="server"OnPageChanged="AspNetPager1_PageChanged">
  50. </webdiyer:AspNetPager>
  52. </form>
  53. </body>
  54. </html>

cs后台部分代码：

Code:
  1. usingSystem;
  2. usingSystem.Collections.Generic;
  3. usingSystem.Linq;
  4. usingSystem.Web;
  5. usingSystem.Web.UI;
  6. usingSystem.Web.UI.WebControls;
  7. usingSystem.Data;
  8. usingSystem.Data.SqlClient;
  9. usingSystem.Configuration;
  11. namespaceLearningAspNet.无刷新分页
  12. {
  13. publicpartialclassWebForm1:System.Web.UI.Page
  14. {
  15. stringconnStr=ConfigurationManager.ConnectionStrings["studentConnectionString"].ToString();
  16. protectedvoidPage_Load(objectsender,EventArgse)
  17. {
  18. if(!IsPostBack)
  19. {
  20. bind();
  21. }
  22. }
  23. ///<summary>
  24. ///绑定数据
  25. ///</summary>
  26. privatevoidbind()
  27. {
  28. this.AspNetPager1.RecordCount=getRecordCount();//总记录数
  29. intcurPage=this.AspNetPager1.CurrentPageIndex;//当前页的索引
  30. intcount=this.AspNetPager1.PageSize=3;//每页显示条数
  31. Repeater1.DataSource=getData(curPage,count,"stuinfo","sid");
  32. Repeater1.DataBind();
  33. }
  34. ///<summary>
  35. ///获取数据源
  36. ///</summary>
  37. ///<paramname="curPage">当前页</param>
  38. ///<paramname="count">每页显示的条数</param>
  39. ///<paramname="tblName">表名</param>
  40. ///<paramname="colum">主键（标识）</param>
  41. ///<returns></returns>
  42. privateDataSetgetData(intcurPage,intcount,stringtblName,stringcolum){
  46. SqlConnectionconn=newSqlConnection(connStr);
  47. try
  48. {
  50. conn.Open();
  51. DataSetds=newDataSet();
  52. SqlCommandcmd=newSqlCommand();
  53. SqlDataAdapterda=newSqlDataAdapter(cmd);
  54. cmd.Connection=conn;
  55. cmd.CommandType=CommandType.StoredProcedure;
  56. cmd.CommandText="page";
  57. //给存储过程添加参数
  58. cmd.Parameters.Add(newSqlParameter("@currentPage",SqlDbType.Int));
  59. cmd.Parameters.Add(newSqlParameter("@count",SqlDbType.Int));
  60. cmd.Parameters.Add(newSqlParameter("@tableName",SqlDbType.VarChar));
  61. cmd.Parameters.Add(newSqlParameter("@column",SqlDbType.VarChar));
  62. //给参数赋值
  63. da.SelectCommand.Parameters["@currentPage"].Value=curPage;
  64. da.SelectCommand.Parameters["@count"].Value=count;
  65. da.SelectCommand.Parameters["@tableName"].Value=tblName;
  66. da.SelectCommand.Parameters["@column"].Value=colum;
  68. //da.SelectCommand=cmd;
  69. da.Fill(ds);
  71. returnds;
  75. }
  76. catch(Exception)
  77. {
  79. throw;
  80. }
  81. finally{
  82. conn.Close();
  83. }
  84. }
  85. ///<summary>
  86. ///查询总记录数
  87. ///</summary>
  88. ///<returns></returns>
  89. privateintgetRecordCount()
  90. {
  91. inti=0;
  92. SqlConnectionconn=newSqlConnection(connStr);
  93. conn.Open();
  94. stringsql="selectcount(*)fromstuinfo";//查询处总记录数
  95. SqlDataAdapterda=newSqlDataAdapter(sql,conn);
  96. objectobj=da.SelectCommand.ExecuteScalar();//查询结果的第一行第一列--总记录条数
  97. i=int.Parse(obj.ToString());//总记录条数
  98. conn.Close();
  99. returni;
  101. }
  102. ///<summary>
  103. ///翻页事件
  104. ///</summary>
  105. ///<paramname="sender"></param>
  106. ///<paramname="e"></param>
  107. protectedvoidAspNetPager1_PageChanged(objectsender,EventArgse)
  108. {
  109. bind();
  110. }
  111. ///<summary>
  112. ///DataList控件中点击任意一列的按钮会发生
  113. ///</summary>
  114. ///<paramname="source"></param>
  115. ///<paramname="e"></param>
  116. protectedvoidRepeater1_ItemCommand(objectsource,RepeaterCommandEventArgse)
  117. {
  118. if(e.CommandName=="btn")
  119. {
  120. Label1.Text="我的学号是"+e.CommandArgument.ToString();
  121. Label1.Style["color"]="red";
  122. }
  123. }
  124. ///<summary>
  125. ///每一项绑定的时候
  126. ///</summary>
  127. ///<paramname="sender"></param>
  128. ///<paramname="e"></param>
  129. protectedvoidRepeater1_ItemDataBound(objectsender,RepeaterItemEventArgse)
  130. {
  131. if(e.Item.ItemType==ListItemType.Item)
  132. {
  133. Buttonbtn=(Button)e.Item.FindControl("Button1");//找到按钮
  134. btn.Text="汇报";
  135. }elseif(e.Item.ItemType==ListItemType.AlternatingItem)
  136. {
  137. Buttonbtn=(Button)e.Item.FindControl("Button1");
  138. btn.Text="汇报";
  139. }
  140. }
  141. }
  142. }

数据库部分，分页存储过程：

Code:
  1. --存储过程实现灵活的分页
  2. ifobject_id('page','p')isnotnull
  3. dropprocpage
  4. go
  5. createprocpage
  6. @currentPageint=1,--要查询第几页
  7. @countint=10,--每页显示几条
  8. @tableNamevarchar(20),--表名
  9. @columnvarchar(20)--列名
  10. as
  11. declare@sqlnvarchar(1000)
  12. set@sql=N'selecttop'+cast(@countasnvarchar(3))
  13. set@sql=@sql+N'*from'+@tableName+'where'+@column+'notin('
  14. set@sql=@sql+N'selecttop'+cast(((@currentPage-1)*@count)asnvarchar(3))
  15. set@sql=@sql+@column+N'from'+@tableName+')'
  17. exec(@sql)
  18. go
  19. execpage1,2,'stuinfo','sid'--测试存储过程

由于时间有限，代码写的很仓促，很凌乱。大家请勿笑话！

分享到：
| php文件中js脚本块获取php变量值
评论
发表评论

您还没有登录,请您登录后再发表评论

相关推荐

Magicbox
Global site tag (gtag.js) - Google Analytics