分页 //绑定GridView

ASP.NET分页

最新推荐文章于 2025-09-06 22:56:13 发布

H_MZ

最新推荐文章于 2025-09-06 22:56:13 发布

阅读量88

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/gaoxuzhao/archive/2011/10/13/2209870.html

本文介绍了一个使用ASP.NET和SQLServer实现的数据分页功能。通过连接数据库并填充数据集，然后利用GridView控件显示数据，并实现了基本的分页导航功能。

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bind();
}
}
public void bind()
{
string connStr = "Data Source=(local);Database=wxd;Uid=sa;Pwd=sa";
string SqlStr = "select * from Admin";
DataSet ds = new DataSet();
try
{
SqlConnection conn = new SqlConnection(connStr);
if (conn.State.ToString() == "Closed") conn.Open();
SqlDataAdapter da = new SqlDataAdapter(SqlStr, conn);
da.Fill(ds, "Admin");
if (conn.State.ToString() == "Open") conn.Close();
GridView1.DataSource = ds.Tables[0].DefaultView;
GridView1.DataBind();

btnFirst.Enabled = true;
btnPrev.Enabled = true;
btnNext.Enabled = true;
btnLast.Enabled = true;

LblCurrentIndex.Text = "第 " + (GridView1.PageIndex + 1).ToString() + " 页";
LblPageCount.Text = "共 " + GridView1.PageCount.ToString() + " 页";
LblRecordCount.Text = "总共 " + ds.Tables[0].Rows.Count.ToString() + " 条";
if (GridView1.PageIndex == 0)
{
btnFirst.Enabled = false;
btnPrev.Enabled = false;
}
else if (GridView1.PageIndex == GridView1.PageCount-1)
{
btnNext.Enabled = false;
btnLast.Enabled = false;
}
pageDropDownList.Items.Clear();
for (int i = 1; i < GridView1.PageCount+1; i++)
{
pageDropDownList.Items.Add(i.ToString());
}
pageDropDownList.SelectedValue = Convert.ToString(GridView1.PageIndex + 1);
// 计算生成分页页码,分别为："首页" "上一页" "下一页" "尾页"
btnFirst.CommandName = "1";
btnPrev.CommandName = (GridView1.PageIndex == 0 ? "1" : GridView1.PageIndex.ToString());

btnNext.CommandName = (GridView1.PageCount == 1 ? GridView1.PageCount.ToString() : (GridView1.PageIndex + 2).ToString());
btnLast.CommandName = GridView1.PageCount.ToString();

}
catch (Exception ex)
{
Response.Write("数据库错误，错误原因：" + ex.Message);
Response.End();
}

}
//分页
protected void PagerButtonClick(object sender, EventArgs e)
{
GridView1.PageIndex = Convert.ToInt32(((LinkButton)sender).CommandName) - 1;
bind();
}
//跳转页
protected void pageDropDownList_SelectedIndexChanged(object sender, EventArgs e)
{
GridView1.PageIndex = Convert.ToInt32(pageDropDownList.SelectedValue) - 1;
bind();
}