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>