查询分页
自己写的分页函数 首页( LinkButton1) 上一页 ( LinkButton2)下一页( LinkButton3) 尾页( LinkButton4)但是查询的时候分页功能就不起作用了。应该怎么写查询函数?
//private void PageBind()
//{
// DataSet ds = DataAccess.Class1.Select("select * from expert");
// if (ds.Tables[0].Rows.Count != 0)
// {
// int curpage = int.Parse(Label6.Text);
// PagedDataSource pds = new PagedDataSource();
// pds.AllowPaging = true;
// pds.PageSize = 2;
// pds.DataSource = ds.Tables[0].DefaultView;
// pds.CurrentPageIndex = curpage-1;
// LinkButton1.Enabled = true;
// LinkButton2.Enabled = true;
// LinkButton3.Enabled = true;
// LinkButton4.Enabled = true;
// if (curpage == 1)
// {
// LinkButton1.Enabled = false;
// LinkButton2.Enabled = false;
// }
// if (curpage == pds.PageCount)
// {
// LinkButton3.Enabled = false;
// LinkButton4.Enabled = false;
// }
// Label7.Text = Convert.ToString(pds.PageCount);
// Label7.Visible = true;
// Label6.Visible = true;
// GridView1.DataSource = pds;
// GridView1.DataBind();
// }
//}
protected void LinkButton1_Click(object sender, EventArgs e)
{
Label6.Text = "1";
PageBind();
}
protected void LinkButton2_Click(object sender, EventArgs e)
{
Label6.Text = Convert.ToString(Convert.ToInt32(Label6.Text)-1);
PageBind();
}
protected void LinkButton3_Click(object sender, EventArgs e)
{
Label6.Text = Convert.ToString(Convert.ToInt32(Label6.Text)+1);
PageBind();
}
protected void LinkButton4_Click(object sender, EventArgs e)
{
Label6.Text = Label7.Text;
LinkButton3.Enabled = false;
PageBind();
}
--------------------编程问答-------------------- http://www.webdiyer.com/AspNetPagerDocs/
你还是自己用分页 控件把
方便多了 --------------------编程问答-------------------- 查询的时候DataSet ds = DataAccess.Class1.Select("select * from expert");要加where
并且这个DataSet 是全局的。
补充:.NET技术 , ASP.NET