private void WorkingWithClientsDataClientsForm_Load(object sender, EventArgs e) { labelClientsDBInfo.Text = "База данных клиентов на " + DateTime.Today.ToString("dd-MM-yyyy"); clientsContext = new ClientsEntities(); //инициализируем контекст в конструкторе формы var clientsNames = from d in clientsContext.People select d; dataGridViewForEmployees.DataSource = clientsNames .Select(item_list => new { ID = item_list.PersonID, First_Name = item_list.FirstName, Last_Name = item_list.LastName, Hire_Date = item_list.HireDate, Enrollment_Date = item_list.EnrollmentDate }).ToList(); dataGridViewForEmployees.Columns["ID"].Visible = false; }
private void WorkingWithClientsDataForm_Load(object sender, EventArgs e) { clientsContext = new ClientsEntities(); //инициализируем контекст в конструкторе формы SetLastDateUpdate(); //устанавливаем значение даты последнего добавленного клиента var clientsNames = from d in clientsContext.People select d; dataGridViewForEmployees.DataSource = clientsNames .Select(item_list => new { ID = item_list.PersonID, First_Name = item_list.FirstName, Last_Name = item_list.LastName, Hire_Date = item_list.HireDate, Enrollment_Date = item_list.EnrollmentDate }).ToList(); dataGridViewForEmployees.Columns["ID"].Visible = false; }