// paging for repeater private void FetchData(int take, int pageSize) { using (NORTHWNDEntities dc = new NORTHWNDEntities()) { var query = from p in dc.Employees .OrderBy(o => o.FirstName) .Take(take) .Skip(pageSize) select new { ID = p.EmployeeID, Name = p.FirstName + "" + p.LastName, Count = dc.Employees.Count() }; PagedDataSource page = new PagedDataSource(); page.AllowCustomPaging = true; page.AllowPaging = true; page.DataSource = query; page.PageSize = 10; rEmployees.DataSource = page; rEmployees.DataBind(); if (!IsPostBack) { RowCount = query.First().Count; CreatePagingControl(); } } }
protected void grdEmployers_SelectedIndexChanged(object sender, EventArgs e) { int eId = int.Parse(grdEmployers.SelectedDataKey.Value.ToString()); NORTHWNDEntities db = new NORTHWNDEntities(); grdFormView.DataSource = new List<Employee>() { db.Employees.FirstOrDefault(x => x.EmployeeID == eId) }; grdFormView.DataBind(); }
private void GridFill(NORTHWNDEntities db) { //NORTHWNDEntities db = new NORTHWNDEntities(); grdEmployers.DataSource = db.Employees.Select(x => new { Id = x.EmployeeID, FullName = x.FirstName + " " + x.LastName }).ToList(); grdEmployers.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!string.IsNullOrEmpty(Request.QueryString["id"])) { int eId = int.Parse(Request.QueryString["id"]); NORTHWNDEntities db = new NORTHWNDEntities(); grdEmployerView.DataSource = new List<Employee>() { db.Employees.FirstOrDefault(x => x.EmployeeID == eId) }; grdEmployerView.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { NORTHWNDEntities db = new NORTHWNDEntities(); GridFill(db); FetchData(10, 0); //rEmployees.DataSource = db.Employees.ToList(); //rEmployees.DataBind(); lvEmployees.DataSource = db.Employees.ToList(); lvEmployees.DataBind(); } else { plcPaging.Controls.Clear(); CreatePagingControl(); } }
public void grdEmployers_PageIndexChanging(object sender, GridViewPageEventArgs e) { NORTHWNDEntities db = new NORTHWNDEntities(); this.grdEmployers.PageIndex = e.NewPageIndex; GridFill(db); }