2.0中GridView中的分页

来源：互联网发布：淘宝免费赠送编辑：程序博客网时间：2024/05/16 01:20

string connectionString = ConfigurationManager.ConnectionStrings["xinProductsConnectionString"].ConnectionString;
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString=connectionString;
        string sqlstr = "select * from BoardRoom";
        SqlDataAdapter da=new SqlDataAdapter(sqlstr,conn);
        DataSet ds=new DataSet();

        try
        {
            da.Fill(ds, "word");
            PagedDataSource pg = new PagedDataSource();
            pg.DataSource = ds.Tables["Word"].DefaultView;
            pg.AllowPaging = true;
            pg.PageSize = 5;
            int currPage;
            if (Request.QueryString["page"] != null)

                currPage = Convert.ToInt32(Request.QueryString["page"]);
            else
                currPage = 1;

pg.CurrentPageIndex = currPage - 1;

LabelCurrpage.Text = "当前页：第" + currPage.ToString() + "页";
LabelTotal.Text = "共有：" + pg.PageCount.ToString() + "页";

            HyperLinkFirstPage.NavigateUrl = Request.CurrentExecutionFilePath + "?page="+Convert.ToInt32(1);
            if (!pg.IsFirstPage)
                HyperLinkNextPage.NavigateUrl = Request.CurrentExecutionFilePath + "?page=" + Convert.ToInt32(currPage - 1);
            if (!pg.IsLastPage)
                HyperLinkPrePage.NavigateUrl = Request.CurrentExecutionFilePath + "?page=" + Convert.ToInt32(currPage + 1);
            HyperLinkLastPage.NavigateUrl = Request.CurrentExecutionFilePath + "?page=" + Convert.ToInt32(pg.PageCount);

            GridView1.DataSource = pg;
            GridView1.DataBind();