private void EmployeeInformationAutoComplete() { EmployeeRepository employeeRepository = new EmployeeRepository(); var employee_list = employeeRepository.selectAll(txt_employee_id.Text); AutoCompleteStringCollection namec = new AutoCompleteStringCollection(); foreach (var list in employee_list) { namec.Add(list.EmployeeID); } txt_employee_id.AutoCompleteCustomSource = namec; }
public void EmployeeList() { try { dg_employees.Columns.Clear(); dg_employees.DataSource = null; var source = new BindingSource(); EmployeeRepository employeeRepository = new EmployeeRepository(); List <Employee> list = employeeRepository.selectAll(txt_filter.Text); source.DataSource = list; dg_employees.DataSource = source; dg_employees.Columns["ID"].Visible = false; dg_employees.Columns["Department"].Visible = false; AddButtonOnGrid(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }