// 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);
}
