復制代碼 代碼如下:
<div>
<webdiyer:AspNetPager runat="server"
AlwaysShow="True" FirstPageText="首頁" LastPageText="尾頁" NextPageText="下一頁"
onpagechanged="AspNetPagerAskAnswer_PageChanged" PrevPageText="上一頁"
PageSize="15">
</webdiyer:AspNetPager>
<br />
</div>
復制代碼 代碼如下:
private void bind(){SqlConnection connection= new SqlConnection(ConfigurationManager.ConnectionStrings["tianzi"].ConnectionString);
SqlCommand cmd = new SqlCommand("select * from ask", connection);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
AspNetPagerAskAnswer.PageSize = 5;//設置分頁大小
AspNetPagerAskAnswer.RecordCount = AskManager.GetAllAsks().Rows.Count;//設置總數據條數
sda.Fill(ds, AspNetPagerAskAnswer.PageSize * (AspNetPagerAskAnswer.CurrentPageIndex - 1), AspNetPagerAskAnswer.PageSize, "asks");//固定不變的
RepeaterAskAnswer.DataSource = ds.Tables["asks"];
RepeaterAskAnswer.DataBind();
}
復制代碼 代碼如下:
protected void AspNetPagerAskAnswer_PageChanged(object sender, EventArgs e)
{
bind();
}
新聞熱點
疑難解答
圖片精選