Datalist分页

aspx.cs

private void Page_Load(object sender, System.EventArgs e)
   {   
    string strconn="database=sql;uid=sa;pwd=123;";
             SqlConnection conn=new SqlConnection(strconn);
    string strcom="select TeacherID,TeacherName,Sex,Birthday from Teacher";
              conn.Open();
    SqlDataAdapter aaa=new SqlDataAdapter(strcom,conn);
    DataSet ds=new DataSet();
    aaa.Fill(ds,"Teacher");
             PagedDataSource pd=new PagedDataSource();
    pd.DataSource=ds.Tables["Teacher"].DefaultView;

             pd.AllowPaging=true;

    pd.PageSize = 5;
    int CurPage;
    if (Request.QueryString["Page"] != null)
     CurPage=Convert.ToInt32(Request.QueryString["Page"]);
    else
     CurPage=1;

    pd.CurrentPageIndex = CurPage-1;
   
    if (!pd.IsFirstPage)
     HyperLink1.NavigateUrl=Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage-1);

    if (!pd.IsLastPage)
    HyperLink2.NavigateUrl=Request.CurrentExecutionFilePath+ "?Page=" + Convert.ToString(CurPage+1);
    this.DataList1.DataSource=pd;
    this.DataList1.DataBind();

   }

html:

<form id="Form1" method="post" runat="server">
    <asp:datalist id="DataList1" style="Z-INDEX: 101; LEFT: 232px; POSITION: absolute; TOP: 152px"
     runat="server">
     <ItemTemplate>
      <%#DataBinder.Eval(Container.DataItem,"TeacherID")%>
      <%#DataBinder.Eval(Container.DataItem,"TeacherName")%>
      <%#DataBinder.Eval(Container.DataItem,"Sex")%>
      <%#DataBinder.Eval(Container.DataItem,"Birthday")%>
     </ItemTemplate>
    </asp:datalist>
    <asp:HyperLink id="HyperLink1" style="Z-INDEX: 102; LEFT: 248px; POSITION: absolute; TOP: 272px"
     runat="server">上一页</asp:HyperLink>
    <asp:HyperLink id="HyperLink2" style="Z-INDEX: 103; LEFT: 392px; POSITION: absolute; TOP: 272px"
     runat="server">下一页</asp:HyperLink></form>