private void OUVRAGE_Load(object sender, EventArgs e) { //Metro Dark Theme this.StyleManager = metroStyleManager1; metroStyleManager1.Theme = MetroThemeStyle.Dark; this.FormBorderStyle = FormBorderStyle.None; //Remplir Les LIstBox Et DataGridView ADO_Connecter.RemplirListBox(listBox_OUVRAGE, "select * from OUVRAGE", "NOMOUVR"); ADO_Connecter.RemplirListBox(listBox_help, "select * from OUVRAGE", "NUMOUVR"); ADO_Connecter.RemplirComboBox(comboBox_classification, "select * from CLASSIFICATION", "LIBRUB"); ADO_Connecter.RemplirComboBox(comboBox_EDITEUR, "select * from EDITEUR", "NOMED"); //initialisation de selection du classification comboBox_classification.SelectedIndex = 0; apres_validation(); }
private void comboBox_classification_SelectedIndexChanged(object sender, EventArgs e) { ADO_Connecter.RemplirListBox(listBox_OUVRAGE, "select * from OUVRAGE where NUMRUB in (select NUMRUB from CLASSIFICATION where LIBRUB = '" + comboBox_classification.SelectedItem.ToString() + "')", "NOMOUVR"); ADO_Connecter.RemplirListBox(listBox_help, "select * from OUVRAGE where NUMRUB in (select NUMRUB from CLASSIFICATION where LIBRUB = '" + comboBox_classification.SelectedItem.ToString() + "')", "NUMOUVR"); listBox_OUVRAGE.SelectedIndex = 0; }