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();