Datalist分页

Datalist分页

2006-12-27 10:44

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>