Private NoEvent as boolean Private Sub Combo_load() if NoEvent then return Try NoEvent = true Type_Op_Load() Gamme_Alu_Load() Type_Ouv_Load() Nb_V_Load() Nb_V_F_Load() Renfort_Load() finally NoEvent = false end try End Sub Private Sub CB_Type_op_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CB_Type_op.SelectedIndexChanged if NoEvent then return Try NoEvent = true Gamme_Alu_Load() Type_Ouv_Load() Nb_V_Load() Nb_V_F_Load() Renfort_Load() finally NoEvent = false end try End Sub Private Sub CB_Gamme_Alu_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CB_Gamme_Alu.SelectedIndexChanged if NoEvent then return Try NoEvent = true Type_Op_Load() Type_Ouv_Load() Nb_V_Load() Nb_V_F_Load() Renfort_Load() finally NoEvent = false end try End Sub Private Sub CB_Type_Ouv_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CB_Type_Ouv.SelectedIndexChanged if NoEvent then return Try NoEvent = true Type_Op_Load() Gamme_Alu_Load() Nb_V_Load() Nb_V_F_Load() Renfort_Load() finally NoEvent = false end try End Sub Private Sub CB_Nb_V_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CB_Nb_V.SelectedIndexChanged if NoEvent then return Try NoEvent = true Type_Op_Load() Gamme_Alu_Load() Type_Ouv_Load() Nb_V_F_Load() Renfort_Load() finally NoEvent = false end try End Sub Private Sub CB_Nb_V_F_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CB_Nb_V_F.SelectedIndexChanged if NoEvent then return Try NoEvent = true Type_Op_Load() Gamme_Alu_Load() Type_Ouv_Load() Nb_V_Load() Renfort_Load() finally NoEvent = false end try End Sub Private Sub CB_renfort_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CB_renfort.SelectedIndexChanged if NoEvent then return Try NoEvent = true Type_Op_Load() Gamme_Alu_Load() Type_Ouv_Load() Nb_V_Load() Nb_V_F_Load() finally NoEvent = false end try End Sub
Private Sub Combo_load() strsql = "Select Distinct Type_Op from q_cas_possible_fab" '"select Distinct Type_Op from q_cas_possible_fab where Gamme_Alu LIKE " & Convert.ToChar(39) & "%" & CB_Gamme_Alu.SelectedItem & "%" & Convert.ToChar(39) & "AND Type_Ouv LIKE " & Convert.ToChar(39) & "%" & CB_Type_Ouv.SelectedItem & "%" & Convert.ToChar(39) & "AND Renfort LIKE " & Convert.ToChar(39) & "%" & CB_renfort.SelectedItem & "%" & Convert.ToChar(39) cmd = New SqlCommand(strsql, con) dr = cmd.ExecuteReader CB_Type_op.Items.Clear() Do While dr.Read CB_Type_op.Items.Add(dr("Type_Op")) Loop dr.Close() strsql = "Select Distinct Gamme_Alu from q_cas_possible_fab" '"select Distinct Gamme_Alu from q_cas_possible_fab where Type_Op LIKE " & Convert.ToChar(39) & "%" & CB_Type_op.SelectedItem & "%" & Convert.ToChar(39) & " AND Type_Ouv LIKE " & Convert.ToChar(39) & "%" & CB_Type_Ouv.SelectedItem & "%" & Convert.ToChar(39) & " AND Renfort LIKE " & Convert.ToChar(39) & "%" & CB_renfort.SelectedItem & "%" & Convert.ToChar(39) cmd = New SqlCommand(strsql, con) dr = cmd.ExecuteReader CB_Gamme_Alu.Items.Clear() Do While dr.Read CB_Gamme_Alu.Items.Add(dr("Gamme_Alu")) Loop dr.Close() strsql = "Select Distinct Type_Ouv from q_cas_possible_fab" '"select Distinct Type_Ouv from q_cas_possible_fab where Type_Op LIKE " & Convert.ToChar(39) & "%" & CB_Type_op.SelectedItem & "%" & Convert.ToChar(39) & " AND Gamme_Alu LIKE " & Convert.ToChar(39) & "%" & CB_Gamme_Alu.SelectedItem & "%" & Convert.ToChar(39) & " AND Renfort LIKE " & Convert.ToChar(39) & "%" & CB_renfort.SelectedItem & "%" & Convert.ToChar(39) cmd = New SqlCommand(strsql, con) dr = cmd.ExecuteReader CB_Type_Ouv.Items.Clear() Do While dr.Read CB_Type_Ouv.Items.Add(dr("Type_Ouv")) Loop dr.Close() strsql = "Select Distinct Nb_V from q_cas_possible_fab" '"select Distinct Nb_V from q_cas_possible_fab where Type_Op LIKE " & Convert.ToChar(39) & "%" & CB_Type_op.SelectedItem & "%" & Convert.ToChar(39) & " AND Gamme_Alu LIKE " & Convert.ToChar(39) & "%" & CB_Gamme_Alu.SelectedItem & "%" & Convert.ToChar(39) & " AND Type_Ouv LIKE " & Convert.ToChar(39) & "%" & CB_Type_Ouv.SelectedItem & "%" & Convert.ToChar(39) & " AND Renfort LIKE " & Convert.ToChar(39) & "%" & CB_renfort.SelectedItem & "%" & Convert.ToChar(39) cmd = New SqlCommand(strsql, con) dr = cmd.ExecuteReader CB_Nb_V.Items.Clear() Do While dr.Read CB_Nb_V.Items.Add(dr("Nb_V")) Loop dr.Close() strsql = "Select Distinct Nb_V_F from q_cas_possible_fab" '"select Distinct Nb_V_F from q_cas_possible_fab where Type_Op LIKE " & Convert.ToChar(39) & "%" & CB_Type_op.SelectedItem & "%" & Convert.ToChar(39) & " AND Gamme_Alu LIKE " & Convert.ToChar(39) & "%" & CB_Gamme_Alu.SelectedItem & "%" & Convert.ToChar(39) & " AND Type_Ouv LIKE " & Convert.ToChar(39) & "%" & CB_Type_Ouv.SelectedItem & "%" & Convert.ToChar(39) & " AND Renfort LIKE " & Convert.ToChar(39) & "%" & CB_renfort.SelectedItem & "%" & Convert.ToChar(39) cmd = New SqlCommand(strsql, con) dr = cmd.ExecuteReader CB_Nb_V_F.Items.Clear() Do While dr.Read CB_Nb_V_F.Items.Add(dr("Nb_V_F")) Loop dr.Close() strsql = "Select Distinct Renfort from q_cas_possible_fab" '"select Distinct Renfort from q_cas_possible_fab where Type_Op LIKE " & Convert.ToChar(39) & "%" & CB_Type_op.SelectedItem & "%" & Convert.ToChar(39) & " AND Gamme_Alu LIKE " & Convert.ToChar(39) & "%" & CB_Gamme_Alu.SelectedItem & "%" & Convert.ToChar(39) & " AND Type_Ouv LIKE " & Convert.ToChar(39) & "%" & CB_Type_Ouv.SelectedItem & "%" & Convert.ToChar(39) cmd = New SqlCommand(strsql, con) dr = cmd.ExecuteReader CB_renfort.Items.Clear() Do While dr.Read CB_renfort.Items.Add(dr("Renfort")) Loop dr.Close() End Sub
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionFor i as integer = 0 to MyCombo.Items.Count-1 if MyTextMemorized.equals(MyCombo.Items(i).ToString) then MyCombo.SelectedIndex = i endif exit for next
Private Sub Type_Op_Load() Type_Op_sav = CB_Type_op.Text strsql = "select Distinct Type_Op from q_cas_possible_fab where Gamme_Alu LIKE " & Convert.ToChar(39) & "%" & CB_Gamme_Alu.SelectedItem & "%" & Convert.ToChar(39) & " AND Type_Ouv LIKE " & Convert.ToChar(39) & "%" & CB_Type_Ouv.SelectedItem & "%" & Convert.ToChar(39) & " AND Renfort LIKE " & Convert.ToChar(39) & "%" & CB_renfort.SelectedItem & "%" & Convert.ToChar(39) '"Select Distinct Type_Op from q_cas_possible_fab" cmd = New SqlCommand(strsql, con) dr = cmd.ExecuteReader CB_Type_op.Items.Clear() Do While dr.Read CB_Type_op.Items.Add(dr("Type_Op")) Loop dr.Close() For i As Integer = 0 To CB_Type_op.Items.Count - 1 If Type_Op_sav.Equals(CB_Type_op.Items(i).ToString) Then CB_Type_op.SelectedIndex = i End If Exit For Next End Sub Private Sub Gamme_Alu_Load() Gamme_Alu_sav = CB_Gamme_Alu.Text strsql = "select Distinct Gamme_Alu from q_cas_possible_fab where Type_Op LIKE " & Convert.ToChar(39) & "%" & CB_Type_op.SelectedItem & "%" & Convert.ToChar(39) & " AND Type_Ouv LIKE " & Convert.ToChar(39) & "%" & CB_Type_Ouv.SelectedItem & "%" & Convert.ToChar(39) & " AND Renfort LIKE " & Convert.ToChar(39) & "%" & CB_renfort.SelectedItem & "%" & Convert.ToChar(39) '"Select Distinct Gamme_Alu from q_cas_possible_fab" cmd = New SqlCommand(strsql, con) dr = cmd.ExecuteReader CB_Gamme_Alu.Items.Clear() Do While dr.Read CB_Gamme_Alu.Items.Add(dr("Gamme_Alu")) Loop dr.Close() For i As Integer = 0 To CB_Gamme_Alu.Items.Count - 1 If Gamme_Alu_sav.Equals(CB_Gamme_Alu.Items(i).ToString) Then CB_Gamme_Alu.SelectedIndex = i End If Exit For Next End Sub Private Sub Type_Ouv_Load() Type_Ouv_sav = CB_Type_Ouv.Text strsql = "select Distinct Type_Ouv from q_cas_possible_fab where Type_Op LIKE " & Convert.ToChar(39) & "%" & CB_Type_op.SelectedItem & "%" & Convert.ToChar(39) & " AND Gamme_Alu LIKE " & Convert.ToChar(39) & "%" & CB_Gamme_Alu.SelectedItem & "%" & Convert.ToChar(39) & " AND Renfort LIKE " & Convert.ToChar(39) & "%" & CB_renfort.SelectedItem & "%" & Convert.ToChar(39) '"Select Distinct Type_Ouv from q_cas_possible_fab" cmd = New SqlCommand(strsql, con) dr = cmd.ExecuteReader CB_Type_Ouv.Items.Clear() Do While dr.Read CB_Type_Ouv.Items.Add(dr("Type_Ouv")) Loop dr.Close() For i As Integer = 0 To CB_Type_Ouv.Items.Count - 1 If Type_Ouv_sav.Equals(CB_Type_Ouv.Items(i).ToString) Then CB_Type_Ouv.SelectedIndex = i End If Exit For Next End Sub Private Sub Nb_V_Load() Nb_V_sav = CB_Nb_V.Text strsql = "select Distinct Nb_V from q_cas_possible_fab where Type_Op LIKE " & Convert.ToChar(39) & "%" & CB_Type_op.SelectedItem & "%" & Convert.ToChar(39) & " AND Gamme_Alu LIKE " & Convert.ToChar(39) & "%" & CB_Gamme_Alu.SelectedItem & "%" & Convert.ToChar(39) & " AND Type_Ouv LIKE " & Convert.ToChar(39) & "%" & CB_Type_Ouv.SelectedItem & "%" & Convert.ToChar(39) & " AND Renfort LIKE " & Convert.ToChar(39) & "%" & CB_renfort.SelectedItem & "%" & Convert.ToChar(39) '"Select Distinct Nb_V from q_cas_possible_fab" ' cmd = New SqlCommand(strsql, con) dr = cmd.ExecuteReader CB_Nb_V.Items.Clear() Do While dr.Read CB_Nb_V.Items.Add(dr("Nb_V")) Loop dr.Close() For i As Integer = 0 To CB_Nb_V.Items.Count - 1 If Nb_V_sav.Equals(CB_Nb_V.Items(i).ToString) Then CB_Nb_V.SelectedIndex = i End If Exit For Next End Sub Private Sub Nb_V_F_Load() Nb_V_F_sav = CB_Nb_V_F.Text strsql = "select Distinct Nb_V_F from q_cas_possible_fab where Type_Op LIKE " & Convert.ToChar(39) & "%" & CB_Type_op.SelectedItem & "%" & Convert.ToChar(39) & " AND Gamme_Alu LIKE " & Convert.ToChar(39) & "%" & CB_Gamme_Alu.SelectedItem & "%" & Convert.ToChar(39) & " AND Type_Ouv LIKE " & Convert.ToChar(39) & "%" & CB_Type_Ouv.SelectedItem & "%" & Convert.ToChar(39) & " AND Renfort LIKE " & Convert.ToChar(39) & "%" & CB_renfort.SelectedItem & "%" & Convert.ToChar(39) '"Select Distinct Nb_V_F from q_cas_possible_fab" cmd = New SqlCommand(strsql, con) dr = cmd.ExecuteReader CB_Nb_V_F.Items.Clear() Do While dr.Read CB_Nb_V_F.Items.Add(dr("Nb_V_F")) Loop dr.Close() For i As Integer = 0 To CB_Nb_V_F.Items.Count - 1 If Nb_V_F_sav.Equals(CB_Nb_V_F.Items(i).ToString) Then CB_Nb_V_F.SelectedIndex = i End If Exit For Next End Sub Private Sub Renfort_Load() Renfort_sav = CB_renfort.Text strsql = "select Distinct Renfort from q_cas_possible_fab where Type_Op LIKE " & Convert.ToChar(39) & "%" & CB_Type_op.SelectedItem & "%" & Convert.ToChar(39) & " AND Gamme_Alu LIKE " & Convert.ToChar(39) & "%" & CB_Gamme_Alu.SelectedItem & "%" & Convert.ToChar(39) & " AND Type_Ouv LIKE " & Convert.ToChar(39) & "%" & CB_Type_Ouv.SelectedItem & "%" & Convert.ToChar(39) '"Select Distinct Renfort from q_cas_possible_fab" ' cmd = New SqlCommand(strsql, con) dr = cmd.ExecuteReader CB_renfort.Items.Clear() Do While dr.Read CB_renfort.Items.Add(dr("Renfort")) Loop dr.Close() For i As Integer = 0 To CB_renfort.Items.Count - 1 If Renfort_sav.Equals(CB_renfort.Items(i).ToString) Then CB_renfort.SelectedIndex = i End If Exit For Next End Sub Private Sub Combo_load() Type_Op_Load() Gamme_Alu_Load() Type_Ouv_Load() Nb_V_Load() Nb_V_F_Load() Renfort_Load() End Sub Private Sub CB_Type_op_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CB_Type_op.SelectedIndexChanged Gamme_Alu_Load() Type_Ouv_Load() Nb_V_Load() Nb_V_F_Load() Renfort_Load() End Sub Private Sub CB_Gamme_Alu_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CB_Gamme_Alu.SelectedIndexChanged Type_Op_Load() Type_Ouv_Load() Nb_V_Load() Nb_V_F_Load() Renfort_Load() End Sub Private Sub CB_Type_Ouv_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CB_Type_Ouv.SelectedIndexChanged Type_Op_Load() Gamme_Alu_Load() Nb_V_Load() Nb_V_F_Load() Renfort_Load() End Sub Private Sub CB_Nb_V_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CB_Nb_V.SelectedIndexChanged Type_Op_Load() Gamme_Alu_Load() Type_Ouv_Load() Nb_V_F_Load() Renfort_Load() End Sub Private Sub CB_Nb_V_F_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CB_Nb_V_F.SelectedIndexChanged Type_Op_Load() Gamme_Alu_Load() Type_Ouv_Load() Nb_V_Load() Renfort_Load() End Sub Private Sub CB_renfort_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CB_renfort.SelectedIndexChanged Type_Op_Load() Gamme_Alu_Load() Type_Ouv_Load() Nb_V_Load() Nb_V_F_Load() End Sub