private void cbFilterStandart_CheckedChanged(object sender, EventArgs e) { switch (cbFilterStandart.CheckState) { case (CheckState.Checked): DataBaseTables data = new DataBaseTables(); data.qrDepartment = filterDepartment + " and [Department_Number] like '%" + tbDepartmentSearch.Text + "%' or [Department_Name] like '%" + tbDepartmentSearch.Text + "%'"; data.dtDepartmentFill(); dgvDepartment.DataSource = data.dtDepartment; dgvDepartment.Columns[0].Visible = false; dgvDepartment.Columns[1].HeaderText = "Номер специальности"; dgvDepartment.Columns[2].HeaderText = "Название специальности"; dgvDepartment.Columns[3].Visible = false; dgvDepartment.Columns[4].HeaderText = "Группа стандартов"; dgvDepartment.Columns[5].Visible = false; break; case (CheckState.Unchecked): dgvDepartmentFill(); for (int i = 0; i < dgvDepartment.RowCount; i++) { for (int j = 0; j < dgvDepartment.ColumnCount; j++) { if (dgvDepartment.Rows[i].Cells[j].Value != null) { if (dgvDepartment.Rows[i].Cells[j].Value.ToString().Contains(tbDepartmentSearch.Text)) { dgvDepartment.Rows[i].Selected = true; } } } } break; } }
private void dgvDepartmentFill() { Action action = () => { try { DataBaseTables data = new DataBaseTables(); filterDepartment = data.qrDepartment; data.dtDepartmentFill(); data.dependency.OnChange += onchangeDepartment; dgvDepartment.DataSource = data.dtDepartment; dgvDepartment.Columns[0].Visible = false; dgvDepartment.Columns[1].HeaderText = "Номер специальности"; dgvDepartment.Columns[2].HeaderText = "Название специальности"; dgvDepartment.Columns[3].Visible = false; dgvDepartment.Columns[4].HeaderText = "Группа стандартов"; dgvDepartment.Columns[5].Visible = false; } catch { } }; Invoke(action); }
private void DepartmentFill() { DataBaseTables dataDepartment = new DataBaseTables(); dataDepartment.dtDepartmentFill(); comboBoxDepartment.DataSource = dataDepartment.dtDepartment; comboBoxDepartment.ValueMember = "ID_Department"; comboBoxDepartment.DisplayMember = "Departments_List"; }
private void cbDepartmentFill() { Action action = () => { DataBaseTables tables = new DataBaseTables(); tables.dtDepartmentFill(); tables.dependency.OnChange += onchangeDepartment; cbDepartment.DataSource = tables.dtDepartment; cbDepartment.ValueMember = "ID_Department"; cbDepartment.DisplayMember = "Departments_List"; }; Invoke(action); }
private void departmentFill() { Action action = () => { try { DataBaseTables data = new DataBaseTables(); data.dtDepartmentFill(); data.dependency.OnChange += onChangeDepartment; cbDepartment.DataSource = data.dtDepartment; cbDepartment.ValueMember = "ID_Department"; cbDepartment.DisplayMember = "Departments_List"; } catch { } }; Invoke(action); }
private void DepartmentLoad() { Action action = () => { try { DataBaseTables tables = new DataBaseTables(); tables.dtDepartmentFill(); tables.dependency.OnChange += Departmentonchange; cbDepartment.DataSource = tables.dtDepartment; cbDepartment.ValueMember = "ID_Department"; cbDepartment.DisplayMember = "Departments_List"; } catch { } }; Invoke(action); Thread threadGroup = new Thread(GroupLoad); threadGroup.Start(); }