自已写的一个分页用户控件

由于做的一个网站中有好多地方用到分页，为了倫赖就写了这个了，记性不好，我怕过段时间忘了其中用到的一些东西！办法很笨，但以我现在的知识，只有用这种咯！

控件前台代码

------------------------------------------------------------------------------------

<table cellSpacing="0" cellPadding="0" width="100%" border="0">
    <tr>
        <td align="center"><b></b>
            <hr width="100%" color="black">
        </td>
    </tr>
    <tr>
        <td style="HEIGHT: 19px" align="center">
            <!--主要区域,用来显示数据记录 --><asp:label id="lab_table" runat="server"></asp:label></td>
    </tr>
    <tr align="center">
        <td>
            <hr width="100%" color="black">
            <!-- 按钮-->
            <table cellSpacing="0" cellPadding="0" border="0">
                <tr align="center" height="25">
                    <td>当前面/总共页：</td>
                    <td align="left"><asp:label id="pagecount" Runat="server">1/10</asp:label>&nbsp;&nbsp;&nbsp;&nbsp;</td>
                    <td><asp:linkbutton id="LinkButton1" runat="server">前一页</asp:linkbutton>&nbsp;&nbsp;&nbsp;&nbsp;</td>
                    <td><asp:linkbutton id="LinkButton2" runat="server">下一页</asp:linkbutton>&nbsp;&nbsp;&nbsp;&nbsp;</td>
                    <td>跳转到：&nbsp;</td>
                    <td><asp:dropdownlist id="DropDownList1" runat="server" CssClass="tbox" Width="60px" Height="22px"></asp:dropdownlist>&nbsp;</td>
                    <td>
                        <asp:Button id="Button1" runat="server" Text="G  O" BorderStyle="Groove" Height="22px"></asp:Button></td>
                </tr>
            </table>
            <asp:Label id="lab_currentPage" runat="server" Visible="False"></asp:Label>
            <asp:Label id="lab_allpage" runat="server" Visible="False"></asp:Label></td>
    </tr>
</table>

控件后台代码
----------------------------------------------------------------------------------------------------------------------

public class Pagecontrol : System.Web.UI.UserControl
    {
        protected System.Web.UI.WebControls.DropDownList DropDownList1;
        protected System.Web.UI.WebControls.Button Button1;
        protected System.Web.UI.WebControls.LinkButton LinkButton1;
        protected System.Web.UI.WebControls.LinkButton LinkButton2;
        protected System.Web.UI.WebControls.Label lab_table;
        protected System.Web.UI.WebControls.Label pagecount;
        protected zqkjy.common.dbcom mydb;    
        //设置属性
        private string strSql;
        protected System.Web.UI.WebControls.Label lab_currentPage;
    
        public string strsql  //查询语句,语句中选择的字段数要和设置的列数相同
        {
            get {return strSql;}
            set {strSql=value;}
        }
        private string strTitle; //行标题,传过来显的标题，注意用逗号隔开
        public string strtitle
        {
            get {return strTitle;}
            set {strTitle=value;}
        }
        private int intRows;
        protected System.Web.UI.WebControls.Label lab_allpage;
     //行数,一页多少行
        public int introws
        {
            get {return intRows;}
            set {intRows=value;}
        }
        private int intCols; //例数
        public int intcols
        {
            get {return intCols;}
            set {intCols=value;}
        }

        private void Page_Load(object sender, System.EventArgs e)
        {
            // 在此处放置用户代码以初始化页面
            string strConn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Request.PhysicalApplicationPath+"/sys_data/"+System.Configuration.ConfigurationSettings.AppSettings["dbpath"].ToString();
            mydb=new zqkjy.common.dbcom(strConn);            
            if(!Page.IsPostBack)
            {
                this.lab_currentPage.Text="1";
                this.initial_dp(this.getPages());
                this.lab_allpage.Text=this.getPages().ToString();
            }
            PagedDataSource mypd=this.retPagedDataSource(1);
            if(mypd==null){this.lab_table.Text="没有任何据！";this.lab_currentPage.Text="0";}
            this.showdate(mypd);            
        }

        Web 窗体设计器生成的代码#region Web 窗体设计器生成的代码
        override protected void OnInit(EventArgs e)
        {
            //
            // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
            //
            InitializeComponent();
            base.OnInit(e);
        }
        
        /**//// <summary>
        ///        设计器支持所需的方法 - 不要使用代码编辑器
        ///        修改此方法的内容。
        /// </summary>
        private void InitializeComponent()
        {
            this.LinkButton1.Click += new System.EventHandler(this.LinkButton1_Click);
            this.LinkButton2.Click += new System.EventHandler(this.LinkButton2_Click);
            this.Button1.Click += new System.EventHandler(this.Button1_Click);
            this.Load += new System.EventHandler(this.Page_Load);

        }
        #endregion    

        显示数据#region 显示数据  
        private void showdate(PagedDataSource objData)
        {
            this.createTableHeade(this.strTitle);
            System.Web.UI.WebControls.DataGrid Rp=new DataGrid();
            Rp.DataSource=objData;
            Rp.DataBind();
            //if(Rp.Items.Count==0)Response.Write("Repeater为空！");return;
            for(int i=0;i<Rp.Items.Count;i++)//行数
            {
                this.lab_table.Text+="<tr height=22 align=center bgcolor='#E0DFE3' onmouseover=\"this.style.backgroundColor='#97AFD0'\" onmouseout=\"this.style.backgroundColor=''\">";
                for(int j=0;j<this.intcols;j++)//例数
                {
                    this.lab_table.Text+="<td>"+Rp.Items[i].Cells[j].Text+"</td>";                    
                }
                //加上删除连接
                this.lab_table.Text+="<td><a href='showit.aspx?id="+Rp.Items[i].Cells[0].Text+"' target=mainframe>查看详情</a></td>";
                this.lab_table.Text+="</tr>";
            }
            this.lab_table.Text+="</table>";
        }
        //会制表头
        private void createTableHeade(string strValue)
        {
            this.lab_table.Text="<table cellSpacing='0' borderColorDark='white' cellPadding='0' borderColorLight='#99CCFF' border='1' width='100%'>";
            this.lab_table.Text+="<tr align=center height=25 bgcolor='#999999'>";
            char[] charValue={','};
            string[] strDate=strValue.Split(charValue);
            for(int i=0;i<this.intcols;i++)
            {
                this.lab_table.Text+="<td>"+strDate[i].ToString().Trim()+"</td>";
            }
            this.lab_table.Text+="<td>操作区</td>";
            this.lab_table.Text+="</tr>";
        }
        // 得到当前页的分页数据
        private PagedDataSource retPagedDataSource(int pages)
        {
            PagedDataSource mypd=new PagedDataSource();
            DataSet myds=this.mydb.GetDataSet(this.strsql);
            //if(myds==null)Response.Write("DataSet为空！");return null;        
            mypd.DataSource=myds.Tables[0].DefaultView;
            
            mypd.AllowPaging=true;
            mypd.PageSize=Convert.ToInt32(this.introws);
            if(this.lab_allpage.Text=="0")this.lab_allpage.Text=mypd.PageCount.ToString();
            if(pages>mypd.PageCount||pages<=0)
            {
                return null;//没有这一页了
            }
            this.pagecount.Text=pages.ToString()+"/"+mypd.PageCount.ToString();//设置显示
            mypd.CurrentPageIndex=pages-1;
            this.lab_currentPage.Text=pages.ToString();
            return mypd;
        }
        //得到页数，共有多少页
        private int getPages()
        {
            PagedDataSource mypd=new PagedDataSource();
            DataSet myds=this.mydb.GetDataSet(this.strsql);
            //if(myds==null)Response.Write("DataSet为空！");return null;
            mypd.DataSource=myds.Tables[0].DefaultView;
            mypd.AllowPaging=true;
            mypd.PageSize=Convert.ToInt32(this.introws);
            return mypd.PageCount;
        }
        //初始化下拉列表
        private void initial_dp(int num)
        {
            this.DropDownList1.Items.Clear();
            for(int i=1;i<=num;i++)
            {
                ListItem li=new ListItem(i.ToString(),i.ToString());
                this.DropDownList1.Items.Add(li);
            }
        }
        #endregion

        private void LinkButton1_Click(object sender, System.EventArgs e)
        {
            int iAllPage=Convert.ToInt32(this.lab_allpage.Text);
            int iCrrentPage=Convert.ToInt32(this.lab_currentPage.Text);
            if(iCrrentPage-1<=0)
            {
                return;
            }
            else
            {
                this.showdate(this.retPagedDataSource(iCrrentPage-1));
            }
        }

        private void LinkButton2_Click(object sender, System.EventArgs e)
        {
            int iAllPage=Convert.ToInt32(this.lab_allpage.Text);
            int iCrrentPage=Convert.ToInt32(this.lab_currentPage.Text);
            if(iCrrentPage+1>iAllPage)
            {
                return;
            }
            else
            {
                this.showdate(this.retPagedDataSource(iCrrentPage+1));
            }
        }

        private void Button1_Click(object sender, System.EventArgs e)
        {
            int iNum=Convert.ToInt32(this.DropDownList1.SelectedValue);
            int iCrrentPage=Convert.ToInt32(this.lab_currentPage.Text);
            if(iNum==iCrrentPage)
            {
                return;
            }
            else
            {
                this.showdate(this.retPagedDataSource(iNum));
            }
        }
    }

在其页中调用
----------------------------------------------------------------------------------------------------------------------------
uc1=(Pagecontrol)Page.LoadControl("Pagecontrol.ascx");  //加载控件 
this.uc1.strtitle="列1,列2,列3,列4,列5";//设置列标题
this.uc1.strsql="select 列1,列2,列3,列4,列5 from tablename"//设置查询语句
this.uc1.introws=15;//设置行数
 this.uc1.intcols=3;//设置列数
this.p1.Controls.Add(uc1);//p1为PlaceHolder控件

 说明
------------------------------------------------------------------------------------------------------------------------