解决方案 »
- 如何去掉Form的HTML代码?
- 跪求高手指点,跨系统登录问题。。。
- Global.asax 未被执行是怎么回事?
- 急救:在没有wwwroot的服务器上装程序,怎么解决问题.
- 如果在asp.net中嵌入Autodesk Express Viewer插件
- 如何实现这个循环 ??
- 用C#计算两日期之间的差可以使用DATADIFF吗?
- 关于.net问题,请各位大虾帮帮忙!在线急等
- 两个数据源绑定同一个DATAGRID控件如何分页?
- DataGrid的删除问题,如果datagrid按钮列中删除按钮类型为pushbutton,则刷新页面,若为linkbutton则正常!不知何解?
- 脚本映射和伪静态有何不同?
- 谁 vs2005 甘特图控件 啊?我要实现网页上的 甘特图,需要c#.net实现的!vs2005 甘特图控件 也行!
分页控件例子<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);
}
}
参考
分页速度体验
后台:
public void datalistbind()
{
//数据源
BLL.NewsBLL ne = new BLL.NewsBLL();
DataTable dt = ne.NewsDatalist(); //设置当前页
int curpage = Convert.ToInt32(Label_pageNow.Text.Trim()); //分页设置
PagedDataSource pds = new PagedDataSource();
pds.DataSource = dt.DefaultView;
pds.AllowPaging = true;
pds.PageSize = 10;
pds.CurrentPageIndex = curpage - 1;//当前的索引,当前页
Label_TotalPages.Text = pds.PageCount.ToString();//共有的页数 //分页了
LinkButton_Finlly.Enabled = true;
LinkButton_First.Enabled = true;
LinkButton_Next.Enabled = true;
LinkButton_Up.Enabled = true; if (curpage == 1)
{
LinkButton_Up.Enabled = false;
LinkButton_First.Enabled = false;
}
if(curpage == pds.PageCount)
{
LinkButton_Next.Enabled = false;
LinkButton_Finlly.Enabled = false;
}
DataList1.DataSource = pds;
DataList1.DataBind();
} protected void LinkButton_Finlly_Click(object sender, EventArgs e)
{
Label_pageNow.Text = Label_TotalPages.Text;
this.datalistbind();
} protected void LinkButton_Up_Click(object sender, EventArgs e)
{
Label_pageNow.Text = Convert.ToString(Convert.ToInt32(Label_pageNow.Text)-1);
this.datalistbind();
} protected void LinkButton_Next_Click(object sender, EventArgs e)
{
Label_pageNow.Text = Convert.ToString(Convert.ToInt32(Label_pageNow.Text)+1);
this.datalistbind();
} protected void LinkButton_First_Click(object sender, EventArgs e)
{
Label_pageNow.Text = "1";
this.datalistbind();
}