protected void Page_Load(object sender, EventArgs e)
        {
            var employeeIdString = Request.Params["Id"];
            if (employeeIdString == null)
            {
                Response.Redirect("EmployeesGrid.aspx");
            }

            var employeeId = int.Parse(employeeIdString);

            NorthwindEntities context = new NorthwindEntities();
            var employee = context.Employees
                            .Where(x => x.EmployeeID == employeeId)
                            .Select(x=> new Emp
                            {
                                TitleOfCourtesy = x.TitleOfCourtesy,
                                FirstName = x.FirstName,
                                LastName = x.LastName,
                                Title = x.Title,
                                BirthDate = x.BirthDate,
                                HireDate = x.HireDate,
                                Adress = x.Address,
                                City = x.City,
                                Country = x.Country,
                                Region = x.Region
                            })
                            .ToList();

            this.DetailsViewEmployee.DataSource = employee;
            this.DetailsViewEmployee.DataBind();
        }
 public IQueryable<Employees> GridViewEmployees_GetData()
 {
     NorthwindEntities context = new NorthwindEntities();
     return context.Employees.OrderBy(e => e.EmployeeID);
 }
 public EmployeesListView()
 {
     this.dbContext = new NorthwindEntities();
 }