Ejemplo n.º 1
0
        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;
        }