private void RebindOrders(int employeeId) { var db = new NorthwindEntities(); this.GridViewOrders.DataSource = db.Orders.Where(x => x.EmployeeID == employeeId).ToList(); this.GridViewOrders.DataBind(); this.UpdateProgress.Attributes.CssStyle["display"] = "none"; }
protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { var data = new NorthwindEntities(); this.GridViewEmployees.DataSource = SelectEmployees().ToList(); this.GridViewEmployees.DataBind(); } }
public IQueryable<EmployeeViewModel> SelectEmployees() { var db = new NorthwindEntities(); var employees = db.Employees.Select( e => new EmployeeViewModel { Address = e.Address, EmployeeID = e.EmployeeID, FirstName = e.FirstName, LastName = e.LastName, Title = e.Title }).OrderBy(e => e.EmployeeID); return employees; }