修改的一个REPEATER的分页程序,将它弄成用户控件了,方便以后使用了

这是修改的一个1.1的一个REpeater的分页程序,现在改成2.0的了,可以通用了,呵呵,小弟技术烂,有大虾的请指教啊

前台是

<% @ Control Language = " C# "  AutoEventWireup = " true "  CodeFile = " Page.ascx.cs "  Inherits = " Page "   %>
< table width = " 100% "  border = " 0 "  cellpadding = " 2 "  cellspacing = " 1 "  bgcolor = " #CCCCCC " >
     < tr valign = " middle "  bgcolor = " #FFFFFF " >
         < td height = " 25 " >
            共
             < asp:Literal ID = " RecordCount "  runat = " server " ></ asp:Literal >
            条记录 & nbsp;
         </ td >
         < td >
            共有
             < asp:Literal ID = " PageCount "  runat = " server " ></ asp:Literal >
            页
         </ td >
         < td >
            当前第
             < asp:Literal ID = " Pageindex "  runat = " server " ></ asp:Literal >
            页
         </ td >
         < td >
             < asp:HyperLink ID = " FirstPage "  runat = " server "  Text = " 首页 " ></ asp:HyperLink >
             < asp:HyperLink ID = " PrevPage "  runat = " server "  Text = " 上一页 " ></ asp:HyperLink >
             < asp:HyperLink ID = " NextPage "  runat = " server "  Text = " 下一页 " ></ asp:HyperLink >
             < asp:HyperLink ID = " LastPaeg "  runat = " server "  Text = " 尾页 " ></ asp:HyperLink ></ td >
         < td >
            跳转到
             < asp:Literal ID = " Literal1 "  runat = " server " ></ asp:Literal >
            页
         </ td >
     </ tr >
</ table >

 

using  System;
using  System.Data;
using  System.Configuration;
using  System.Collections;
using  System.Web;
using  System.Web.Security;
using  System.Web.UI;
using  System.Web.UI.WebControls;
using  System.Web.UI.WebControls.WebParts;
using  System.Web.UI.HtmlControls;
using  System.Text;
using  System.Data.OleDb;

public   partial   class  Page : System.Web.UI.UserControl
... {
    private void Page_Load(object sender, System.EventArgs e)
    ...{
        //这个是不能少的,不然ASPX页面就不能用这控件里的函数了
    }
    public void Initialize(string ConnectionString, Repeater DataPanl, string SelectCommand, string PageUrl)
    ...{
        OleDbConnection conn = new OleDbConnection(ConnectionString);
        conn.Open();
        OleDbDataAdapter oda = new OleDbDataAdapter(SelectCommand, conn);
        DataSet ds = new DataSet();
        oda.Fill(ds);
        conn.Close();
        try
        ...{
            PagedDataSource pds = new PagedDataSource();
            pds.DataSource = ds.Tables[0].DefaultView;
            pds.AllowPaging = true;
            pds.PageSize = 5;
            int CurPage;
            if (Request.QueryString["Page"] != null)
            ...{
                CurPage = Convert.ToInt32(Request.QueryString["page"]);
            }
            else
            ...{
                CurPage = 1;
            }
            pds.CurrentPageIndex = CurPage - 1;
            DataPanl.DataSource = pds;
            DataPanl.DataBind();
            RecordCount.Text = pds.DataSourceCount.ToString();
            PageCount.Text = pds.PageCount.ToString();
            Pageindex.Text = CurPage.ToString();
            Literal1.Text = PageList(pds.PageCount, CurPage, PageUrl);


            FirstPage.NavigateUrl = PageUrl + "page=1";
            PrevPage.NavigateUrl = PageUrl + "page=" + (CurPage - 1);
            NextPage.NavigateUrl = PageUrl + "page=" + (CurPage + 1);
            LastPaeg.NavigateUrl = PageUrl + "page=" + pds.PageCount.ToString();

            if (CurPage <= 1 && pds.PageCount <= 1)
            ...{
                FirstPage.NavigateUrl = "";
                PrevPage.NavigateUrl = "";
                NextPage.NavigateUrl = "";
                LastPaeg.NavigateUrl = "";

            }
            if (CurPage <= 1 && pds.PageCount > 1)
            ...{
                FirstPage.NavigateUrl = "";
                PrevPage.NavigateUrl = "";



            }
            if (CurPage >= pds.PageCount)
            ...{
                NextPage.NavigateUrl = "";
                LastPaeg.NavigateUrl = "";

            }

        }
        catch (Exception error)
        ...{
            Response.Write(error.ToString());
        }
        finally
        ...{

        }
    }
    public void Initialize(string ConnectionString, DataList DataPanl, string SelectCommand, string PageUrl)
    ...{
        OleDbConnection conn = new OleDbConnection(ConnectionString);
        conn.Open();
        OleDbDataAdapter oda = new OleDbDataAdapter(SelectCommand, conn);
        DataSet ds = new DataSet();
        oda.Fill(ds);
        conn.Close();
        try
        ...{
            PagedDataSource pds = new PagedDataSource();
            pds.DataSource = ds.Tables[0].DefaultView;
            pds.AllowPaging = true;
            pds.PageSize = 5;
            int CurPage;
            if (Request.QueryString["Page"] != null)
            ...{
                CurPage = Convert.ToInt32(Request.QueryString["page"]);
            }
            else
            ...{
                CurPage = 1;
            }
            pds.CurrentPageIndex = CurPage - 1;
            DataPanl.DataSource = pds;
            DataPanl.DataBind();
            RecordCount.Text = pds.DataSourceCount.ToString();
            PageCount.Text = pds.PageCount.ToString();
            Pageindex.Text = CurPage.ToString();
            Literal1.Text = PageList(pds.PageCount, CurPage, PageUrl);


            FirstPage.NavigateUrl = PageUrl + "page=1";
            PrevPage.NavigateUrl = PageUrl + "page=" + (CurPage - 1);
            NextPage.NavigateUrl = PageUrl + "page=" + (CurPage + 1);
            LastPaeg.NavigateUrl = PageUrl + "page=" + pds.PageCount.ToString();

            if (CurPage <= 1 && pds.PageCount <= 1)
            ...{
                FirstPage.NavigateUrl = "";
                PrevPage.NavigateUrl = "";
                NextPage.NavigateUrl = "";
                LastPaeg.NavigateUrl = "";

            }
            if (CurPage <= 1 && pds.PageCount > 1)
            ...{
                FirstPage.NavigateUrl = "";
                PrevPage.NavigateUrl = "";



            }
            if (CurPage >= pds.PageCount)
            ...{
                NextPage.NavigateUrl = "";
                LastPaeg.NavigateUrl = "";

            }

        }
        catch (Exception error)
        ...{
            Response.Write(error.ToString());
        }
        finally
        ...{

        }
    }
    public void Initialize(string ConnectionString, GridView DataPanl, string SelectCommand, string PageUrl)
    ...{
        OleDbConnection conn = new OleDbConnection(ConnectionString);
        conn.Open();
        OleDbDataAdapter oda = new OleDbDataAdapter(SelectCommand, conn);
        DataSet ds = new DataSet();
        oda.Fill(ds);
        conn.Close();
        try
        ...{
            PagedDataSource pds = new PagedDataSource();
            pds.DataSource = ds.Tables[0].DefaultView;
            pds.AllowPaging = true;
            pds.PageSize = 5;
            int CurPage;
            if (Request.QueryString["Page"] != null)
            ...{
                CurPage = Convert.ToInt32(Request.QueryString["page"]);
            }
            else
            ...{
                CurPage = 1;
            }
            pds.CurrentPageIndex = CurPage - 1;
            DataPanl.DataSource = pds;
            DataPanl.DataBind();
            RecordCount.Text = pds.DataSourceCount.ToString();
            PageCount.Text = pds.PageCount.ToString();
            Pageindex.Text = CurPage.ToString();
            Literal1.Text = PageList(pds.PageCount, CurPage, PageUrl);


            FirstPage.NavigateUrl = PageUrl + "page=1";
            PrevPage.NavigateUrl = PageUrl + "page=" + (CurPage - 1);
            NextPage.NavigateUrl = PageUrl + "page=" + (CurPage + 1);
            LastPaeg.NavigateUrl = PageUrl + "page=" + pds.PageCount.ToString();

            if (CurPage <= 1 && pds.PageCount <= 1)
            ...{
                FirstPage.NavigateUrl = "";
                PrevPage.NavigateUrl = "";
                NextPage.NavigateUrl = "";
                LastPaeg.NavigateUrl = "";

            }
            if (CurPage <= 1 && pds.PageCount > 1)
            ...{
                FirstPage.NavigateUrl = "";
                PrevPage.NavigateUrl = "";



            }
            if (CurPage >= pds.PageCount)
            ...{
                NextPage.NavigateUrl = "";
                LastPaeg.NavigateUrl = "";

            }

        }
        catch (Exception error)
        ...{
            Response.Write(error.ToString());
        }
        finally
        ...{

        }
    }
    public void Initialize(string ConnectionString, DataGrid DataPanl, string SelectCommand, string PageUrl)
    ...{
        OleDbConnection conn = new OleDbConnection(ConnectionString);
        conn.Open();
        OleDbDataAdapter oda = new OleDbDataAdapter(SelectCommand, conn);
        DataSet ds = new DataSet();
        oda.Fill(ds);
        conn.Close();
        try
        ...{
            PagedDataSource pds = new PagedDataSource();
            pds.DataSource = ds.Tables[0].DefaultView;
            pds.AllowPaging = true;
            pds.PageSize = 5;
            int CurPage;
            if (Request.QueryString["Page"] != null)
            ...{
                CurPage = Convert.ToInt32(Request.QueryString["page"]);
            }
            else
            ...{
                CurPage = 1;
            }
            pds.CurrentPageIndex = CurPage - 1;
            DataPanl.DataSource = pds;
            DataPanl.DataBind();
            RecordCount.Text = pds.DataSourceCount.ToString();
            PageCount.Text = pds.PageCount.ToString();
            Pageindex.Text = CurPage.ToString();
            Literal1.Text = PageList(pds.PageCount, CurPage, PageUrl);


            FirstPage.NavigateUrl = PageUrl + "page=1";
            PrevPage.NavigateUrl = PageUrl + "page=" + (CurPage - 1);
            NextPage.NavigateUrl = PageUrl + "page=" + (CurPage + 1);
            LastPaeg.NavigateUrl = PageUrl + "page=" + pds.PageCount.ToString();

            if (CurPage <= 1 && pds.PageCount <= 1)
            ...{
                FirstPage.NavigateUrl = "";
                PrevPage.NavigateUrl = "";
                NextPage.NavigateUrl = "";
                LastPaeg.NavigateUrl = "";

            }
            if (CurPage <= 1 && pds.PageCount > 1)
            ...{
                FirstPage.NavigateUrl = "";
                PrevPage.NavigateUrl = "";



            }
            if (CurPage >= pds.PageCount)
            ...{
                NextPage.NavigateUrl = "";
                LastPaeg.NavigateUrl = "";

            }

        }
        catch (Exception error)
        ...{
            Response.Write(error.ToString());
        }
        finally
        ...{

        }
    }
    public string PageList(int Pagecount, int Pageindex, string PageUrl)
    ...{
        StringBuilder sb = new StringBuilder();
        sb.Append("<select id="Page_Jump" name="Page_Jump" οnchange="window.location='" + PageUrl + "page='+ this.options[this.selectedIndex].value + '';">");

        for (int i = 1; i <= Pagecount; i++)
        ...{
            if (Pageindex == i)
                sb.Append("<option value='" + i + "' selected>" + i + "</option>");
            else
                sb.Append("<option value='" + i + "'>" + i + "</option>");
        }
        sb.Append("</select>");
        return sb.ToString();
    }

}