asp.net分页控件（c#）

最新推荐文章于 2019-10-05 05:33:12 发布

weixin_30909575

最新推荐文章于 2019-10-05 05:33:12 发布

阅读量111

点赞数

文章标签： ui xhtml c#

原文链接：http://www.cnblogs.com/majiangquan/archive/2009/04/20/1439832.html

版权

分页是web开发中频繁用的模块，今天做了一个分页控件，与大家共享，首先说明以下：

1、此控件利用DataSet分页，没用采用存储过程分页，也许不适合大批量数据分页。

2、此控件需要结合我上一片文章（“c#操作存储过程的通用封装”）使用。

控件前台代码：

<% @ Control Language = " C# " AutoEventWireup = " true " CodeFile = " commPage.ascx.cs " Inherits = " commPage " %>
< div >
< span > 共 < asp:Label ID = " lblRecordCount " runat = " server " ></ asp:Label > 条 </ span > < span > 当前 < asp:Label
    ID = " lblCurrentPage " runat = " server " />/< asp:Label ID = " lblPageCount " runat = " server "
        Text = " Label " /> 页 & nbsp; </ span > < span class = " bia " >
             < asp:LinkButton ID = " lbnPrevPage " runat = " server " CommandName = " prev " OnCommand = " Page_OnClick " > 上一页 </ asp:LinkButton ></ span >
& nbsp; & nbsp; & nbsp; & nbsp; & nbsp; & nbsp; < span class = " bia " >< asp:LinkButton ID = " lbnNextPage "

runat="server" CommandName="next" OnCommand="Page_OnClick">下一页</asp:LinkButton></span></div>

控件后台代码：

  1 using System;
  2 using System.Collections;
  3 using System.Configuration;
  4 using System.Data;
  5 using System.Linq;
  6 using System.Web;
  7 using System.Web.Security;
  8 using System.Web.UI;
  9 using System.Web.UI.HtmlControls;
10 using System.Web.UI.WebControls;
11 using System.Web.UI.WebControls.WebParts;
12 using System.Xml.Linq;
13 using mjqDb = mjq.zy5777.com;
14 using System.Data.SqlClient;
15
16 public partial class commPage : System.Web.UI.UserControl
17 {
18      // 查询分页数据总数的存储过程名称
19      private string totalNumProc;
20
21      public string TotalNumProc
22     {
23          get { return totalNumProc; }
24          set { totalNumProc = value; }
25     }
26      // 查询分页数据的存储过程名称
27      private string selectProc;
28
29      public string SelectProc
30     {
31          get { return selectProc; }
32          set { selectProc = value; }
33     }
34
35      // 绑定数据的控件
36      private DataList bindControl;
37
38      public DataList BindControl
39     {
40          get { return bindControl; }
41          set { bindControl = value; }
42     }
43
44      private int pageSize;
45
46      public int PageSize
47     {
48          get { return pageSize; }
49          set { pageSize = value; }
50     }
51
52      // 查询分页数据总数的存储过程参数
53      private SqlParameter[] totalParameters;
54
55      public SqlParameter[] Parameters
56     {
57          get { return totalParameters; }
58          set { totalParameters = value; }
59     }
60      // 查询分页数据的存储过程参数
61      private SqlParameter[] selectParameters;
62
63      public SqlParameter[] SelectParameters
64     {
65          get { return selectParameters; }
66          set { selectParameters = value; }
67     }
68      int RecordCount, PageCount, CurrentPage;
69     SqlConnection conn;
70     SqlCommand cmd;
71      protected void Page_Load( object sender, EventArgs e)
72     {
73
74          // 判断是不是第一次请求
75          if ( ! Page.IsPostBack)
76         {
77             ListBind();
78             CurrentPage = 0 ;
79             ViewState[ " PageIndex " ] = 0 ;
80
81              // 计算总共有多少条记录
82             RecordCount = CalculateRecord();
83             lblRecordCount.Text = RecordCount.ToString();
84
85              // 计算总共多少页
86             PageCount = RecordCount / PageSize;
87             lblPageCount.Text = PageCount.ToString();
88             ViewState[ " PageCount " ] = PageCount;
89
90         }
91     }
92      // 计算总页数
93      public int CalculateRecord()
94     {
95          int intCount;
96          string strCount = TotalNumProc;
97         SqlDataAdapter adpt = mjqDb.execStoreProce.createAdpt(totalNumProc, ref cmd, ref conn, Parameters);
98         DataSet dsC = new DataSet();
99         adpt.Fill(dsC);
100          // SqlCommand sqlcmd = new SqlCommand(strCount, sqlcon);
101          // SqlDataReader sdr = sqlcmd.ExecuteReader();
102         DataRow drC = dsC.Tables[ 0 ].Rows[ 0 ];
103          if (Convert.ToInt32(drC[ 0 ]) > 0 )
104         {
105             intCount = Convert.ToInt32(drC[ 0 ]);
106         }
107          else
108         {
109             intCount = 0 ;
110         }
111         adpt.Dispose();
112         dsC.Dispose();
113         cmd.Dispose();
114         conn.Close();
115          return intCount;
116     }
117     ICollection CreateSource()   // 分页数据集合
118     {
119          int StartIndex;
120
121          // 设定导入的起终地址
122         StartIndex = CurrentPage * PageSize;
123          string strSel = SelectProc;
124         DataSet ds = new DataSet();
125         SqlDataAdapter sda = mjqDb.execStoreProce.createAdpt(SelectProc, ref cmd, ref conn, SelectParameters);
126         sda.Fill(ds, StartIndex, PageSize, " jixie " ); // 该句表示将数据源中从StartIndex位置取出PageSize条记录导入DataSet.
127          return ds.Tables[ " jixie " ].DefaultView;
128
129         ds.Dispose();
130         cmd.Dispose();
131         conn.Close();
132     }
133      // 数据绑定
134      public virtual void ListBind()
135     {
136         BindControl.DataSource = CreateSource();
137         BindControl.DataBind();
138         lbnNextPage.Enabled = true ;
139         lbnPrevPage.Enabled = true ;
140          if (CurrentPage == (PageCount - 1 )) lbnNextPage.Enabled = false ;
141          if (CurrentPage == 0 ) lbnPrevPage.Enabled = false ;
142         lblCurrentPage.Text = (CurrentPage + 1 ).ToString();
143     }
144
145      // 上下页
146      public void Page_OnClick(Object sender, CommandEventArgs e)
147     {
148         CurrentPage = ( int )ViewState[ " PageIndex " ];
149         PageCount = ( int )ViewState[ " PageCount " ];
150          string cmd = e.CommandName;
151          // 判断cmd,以判定翻页方向
152          switch (cmd)
153         {
154              case " next " :
155                  if (CurrentPage < (PageCount - 1 )) CurrentPage ++ ;
156                  break ;
157              case " prev " :
158                  if (CurrentPage > 0 ) CurrentPage -- ;
159                  break ;
160         }
161         ViewState[ " PageIndex " ] = CurrentPage;
162         ListBind();
163     }
164 }

165

调用：

<% @ Register Src = " commPage.ascx " TagName = " commPage " TagPrefix = " uc1 " %>
<! DOCTYPE html PUBLIC " -//W3C//DTD XHTML 1.0 Transitional//EN " " http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd " >
< html xmlns = " http://www.w3.org/1999/xhtml " >
< head runat = " server " >
     < title > 无标题页 </ title >
</ head >
< body >
     < form id = " form1 " runat = " server " >
     < div >
         < asp:DataList ID = " dataList " runat = " server " >
             < ItemTemplate >
                 < div >
                     <% #Eval( " title " ) %>
                 </ div >
             </ ItemTemplate >
         </ asp:DataList >
     </ div >
     < div >
         < uc1:commPage ID = " commPage1 " runat = " server "    />
     </ div >
     </ form >
</ body >

</html>

在调用页的后台 page_load函数中设置属性：