using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;public partial class _Default : System.Web.UI.Page ...{ SqlConnection conn = new SqlConnection("server=.;database=Ajax2005;uid=sa;pwd="); protected void Page_Load(object sender, EventArgs e) ...{ if (!IsPostBack) ...{ RepnewInfoDataBind(); } } public void RepnewInfoDataBind() ...{ SqlCommand comm = new SqlCommand(); comm.CommandText = "select * from NewInfo"; comm.Connection = conn; SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = comm; DataTable dt = new DataTable(); //try //{ da.Fill(dt); //创建分页类 PagedDataSource pd = new PagedDataSource(); //填充数据 pd.DataSource = dt.DefaultView; //允许分页 pd.AllowPaging = true; //设置每页显示条数 pd.PageSize = 5; //定义变量用来保存但前索引 int curPage; //判断页面是否有跳转的请求 if (Request.QueryString["Page"] != null) curPage = Convert.ToInt32(Request.QueryString["Page"]); else curPage = 1; pd.CurrentPageIndex = curPage - 1; if (!pd.IsFirstPage) ...{/**/////定义"上一页"超级连接的URL为:当前执行页面的虚拟路径,并传递下一页面的索引植 this.hplback.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(curPage-1); //this.hplend.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + pd.PageCount.ToString(); } this.hplfirst.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=1"; this.hplend.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + pd.PageCount.ToString(); if (!pd.IsLastPage) ...{ this.hplnext.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(curPage + 1); //this.hplfirst.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + pd.FirstIndexInPage.ToString(); } this.RepnewInfo.DataSource = pd; //这个地方赋值一定要用视图pagedatasource,我原来用的datatable就不行了 this.RepnewInfo.DataBind(); //} //catch { } //finally { Response.Write("<script>alert('对不起,数据不存在!')</script>");} } }