Ejemplo n.º 1
0
        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();
        }