62,267
社区成员
发帖
与我相关
我的任务
分享
<asp:GridView ID="GridView1" runat="server" EnableViewState="false">
</asp:GridView>
<webdiyer:AspNetPager ID="AspNetPager1" runat="server" PageSize="10" OnPageChanging="AspNetPager1_PageChanging">
</webdiyer:AspNetPager>using System;
using System.Data;
using Wuqi.Webdiyer;
using ZhongCong.WebForm;
public partial class MySql : System.Web.UI.Page
{
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);
}
}