private void loadRepeater() { var proc = "Select Id,UserName,Password from AppUser "; var dt = new DataTable(); dt = u.ReturnTable(proc); var objPds = new PagedDataSource(); var objDataView = new DataView(dt); objPds.DataSource = objDataView; objPds.AllowPaging = true; objPds.PageSize = 10; int CurPage; if (Request.QueryString["Page"] != null) { CurPage = Convert.ToInt32(Request.QueryString["Page"]); } else { CurPage = 1; } objPds.CurrentPageIndex = CurPage - 1; lblCurrentPage.Text = "Page: " + CurPage.ToString(); if (!objPds.IsFirstPage) { lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1); } if (!objPds.IsLastPage) { lnkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1); } RptData.DataSource = objPds; RptData.DataBind(); }