效运算 Pages = (int)ViewState["PageCounts"];//从ViewState中读取总页参数进行按钮失效运算 //判断四个按钮（首页、上一页、下一页、尾页）状态 if (CurrentPage + 1 > 1) { Fistpage.Enabled = true; Prevpage.Enabled = true; } else { Fistpage.Enabled = false; Prevpage.Enabled = false; } if (CurrentPage == Pages) { Nextpage.Enabled = false; Lastpage.Enabled = false; } else { Nextpage.Enabled = true; Lastpage.Enabled = true; } //数据绑定到DataList控件 DataSet ds = new DataSet(); //核心SQL语句，进行查询运算（决定了分页的效率:)） SqlDataAdapter MyAdapter = new SqlDataAdapter("Select Top "+PageSize+" * from redheadedfile where id
not in(select top "+PageSize*CurrentPage+" id from redheadedfile order by id asc) order by id asc",MyCon()); MyAdapter.Fill(ds,"news"); datalist1.DataSource = ds.Tables["news"].DefaultView; datalist1.DataBind(); //显示Label控件LCurrentPaget和文本框控件gotoPage状态 LCurrentPage.Text = (CurrentPage+1).ToString();
