62,046
社区成员
发帖
与我相关
我的任务
分享
protected void Page_Load(object sender, EventArgs e){
if (!IsPostBack)
{
RepeaterBind();
}}
public void RepeaterBind()
{
.....//初始数据
}
protected void gvlist_PageIndexChanging(object sender, GridViewPageEventArgs e) //分页方法
{
GridView gvw = (GridView)sender;
if (e.NewPageIndex < 0)
{
TextBox pageNum = (TextBox)gvw.BottomPagerRow.FindControl("tbPage");
int Pa = int.Parse(pageNum.Text);
if (Pa <= 0)
gvw.PageIndex = 0;
else
gvw.PageIndex = Pa - 1;
}
else
{
gvw.PageIndex = e.NewPageIndex;
}
.......绑定代码??? 这里怎么绑定不让他加载到初始数据?
}
<asp:GridView ID="GridView1" runat="server" EnableViewState="false">
</asp:GridView>
<webdiyer:AspNetPager ID="AspNetPager1" runat="server" PageSize="10" OnPageChanging="AspNetPager1_PageChanging">
</webdiyer:AspNetPager>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DisplayData(AspNetPager1.PageSize, 1);
}
}
private void DisplayData(int pageSize, int pageIndex)
{
string sqlStr = "select count(*) from 测试";
MySqlData md = new MySqlData();
AspNetPager1.RecordCount = Convert.ToInt32(md.ExecuteScalar(sqlStr));
sqlStr = String.Format("select * from 测试 limit {0},{1}", ((pageIndex - 1) * pageSize).ToString(), pageSize.ToString());
md.SetCommandText(sqlStr);
DataTable dt = md.FillDataTable();
md.Close();
GridView1.DataSource = dt;
GridView1.DataBind();
}
protected void AspNetPager1_PageChanging(object src, PageChangingEventArgs e)
{
AspNetPager1.CurrentPageIndex = e.NewPageIndex;
DisplayData(AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex);
}