1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81
| '--------------TEST-----------------
Private Sub CourAff2(ByVal UnJour As String)
connexionSQL = Module1.Connexion()
Dim mySqlQuery As String = "SELECT `NomProf`,`NomE`,`PrenomE`,`NomSalle`,`HeureDeb`,`HeureFin`, `Jour` FROM Cour, CourEleve, Eleve, Profs, Salle WHERE Cour.IdCour=CourEleve.idCour and Eleve.IdEleve=CourEleve.IdEleve and Cour.IdProf=Profs.idProf and Cour.IdSalle=Salle.idsalle Group By Cour.idcour, NomSalle HAVING jour='" & UnJour & "' ORDER BY jour, HeureDeb asc;"
'Dim mySqlQuery As String = "SELECT `NomProf`,`NomE`,`PrenomE`,`NomSalle`,`HeureDeb`,`HeureFin`,`Jour` FROM Cour, CourEleve, Profs, Eleve, Salle WHERE Cour.IdProf=Profs.idProf and CourEleve.idcour=eleve.idCour and Eleve.idEleve=eleve.idEleve and Cour.IdSalle=Salle.idsalle Group By Cour.idcour, NomSalle HAVING jour='" & UnJour & "' ORDER BY jour, HeureDeb asc;"
Dim mycommand As New MySqlCommand(mySqlQuery, connexionSQL)
Dim myreader As MySqlDataReader = mycommand.ExecuteReader()
Try
'--- vider le ComboBox ---
Select Case UnJour
Case "Lundi"
LstcourLundi.Items.Clear()
Case "Mardi"
LstCourMardi.Items.Clear()
Case "Mercredi"
LstCourMercredi.Items.Clear()
Case "Jeudi"
LstCourJeudi.Items.Clear()
Case "Vendredi"
LstCourVendredi.Items.Clear()
Case "Samedi"
'LstcourSamedi.Items.Clear()
Case "Dimanche"
'LstcourDimanche.Items.Clear()
End Select
If myreader.HasRows Then
'--- tant que le DataReader a une ligne d'enregistrements ---
While myreader.Read
' ajouter la donnée au ComboBox
Select Case UnJour
Case "Lundi"
LstcourLundi.Items.Add(myreader.GetValue(0))
LstcourLundi.Items.Add(myreader.GetValue(1) & " " & myreader.GetValue(2))
LstcourLundi.Items.Add(myreader.GetValue(3))
LstcourLundi.Items.Add(myreader.GetValue(4) & vbTab & myreader.GetValue(5))
LstcourLundi.Items.Add("____________________")
Case "Mardi"
LstCourMardi.Items.Add(myreader.GetValue(0))
LstCourMardi.Items.Add(myreader.GetValue(1) & vbTab & myreader.GetValue(2))
LstCourMardi.Items.Add(myreader.GetValue(3))
LstCourMardi.Items.Add(myreader.GetValue(4) & " " & myreader.GetValue(5))
LstCourMardi.Items.Add("____________________")
Case "Mercredi"
LstCourMercredi.Items.Add(myreader.GetValue(0))
LstCourMercredi.Items.Add(myreader.GetValue(1) & vbTab & myreader.GetValue(2))
LstCourMercredi.Items.Add(myreader.GetValue(3))
LstCourMercredi.Items.Add(myreader.GetValue(4) & " " & myreader.GetValue(5))
LstCourMercredi.Items.Add("____________________")
Case "Jeudi"
LstCourJeudi.Items.Add(myreader.GetValue(0))
LstCourJeudi.Items.Add(myreader.GetValue(1) & vbTab & myreader.GetValue(2))
LstCourJeudi.Items.Add(myreader.GetValue(3))
LstCourJeudi.Items.Add(myreader.GetValue(4) & " " & myreader.GetValue(5))
LstCourJeudi.Items.Add("____________________")
Case "Vendredi"
LstCourVendredi.Items.Add(myreader.GetValue(0))
LstCourVendredi.Items.Add(myreader.GetValue(1) & vbTab & myreader.GetValue(2))
LstCourVendredi.Items.Add(myreader.GetValue(3))
LstCourVendredi.Items.Add(myreader.GetValue(4) & " " & myreader.GetValue(5))
LstCourVendredi.Items.Add("____________________")
Case "Samedi"
'LstcourSamedi.Items.Add(myreader.GetValue(3) & vbTab & myreader.GetValue(4))
'LstcourSamedi.Items.Add(myreader.GetValue(0) & " " & myreader.GetValue(1))
'LstcourSamedi.Items.Add(myreader.GetValue(2))
'LstcourSamedi.Items.Add("____________________")
Case "Dimanche"
'LstcourDimanche.Items.Add(myreader.GetValue(3) & vbTab & myreader.GetValue(4))
'LstcourDimanche.Items.Add(myreader.GetValue(0) & " " & myreader.GetValue(1))
'LstcourDimanche.Items.Add(myreader.GetValue(2))
'LstcourDimanche.Items.Add("____________________")
End Select
End While
End If
Catch ex As Exception
MessageBox.Show(ex.Message)
Finally
If Not (myreader Is Nothing) Then myreader.Close()
End Try
myreader.Close()
connexionSQL.Close()
End Sub |
Partager