private void PopulerChampsGroupes() { sql msql = new sql("SELECT * FROM Participant ORDER BY 6", "A18_Sim_Eq07"); SqlDataReader read = msql.execute(); while (read.Read()) { cboParticipant.Items.Add(read["nomGroupe"]); } read.Close(); }
private void ChargerPersonnes() { sql msql = new sql("SELECT * FROM Personne ORDER BY 1", "A18_Sim_Eq07"); SqlDataReader read = msql.execute(); while (read.Read()) { m_listPersonnes.Add(new Personne(read["Nom"].ToString(), read["Prenom"].ToString(), read["Couriel"].ToString())); } read.Close(); }
private void PopulerChampsCategories() { sql msql = new sql("SELECT * FROM Categorie ORDER BY 2", "A18_Sim_Eq07"); SqlDataReader read = msql.execute(); while (read.Read()) { cmbCategorie.Items.Add(read["NomCategorie"]); } read.Close(); }
private void PopulerChampsCegeps() { sql msql = new sql("SELECT * FROM Cegep ORDER BY 3", "A18_Sim_Eq07"); SqlDataReader read = msql.execute(); while (read.Read()) { cmbCegep.Items.Add(read["nomCegep"]); } read.Close(); }
private void PopulerChampsGroupes() { cmbGroupesExistants.Items.Add("Aucun"); cmbGroupesExistants.SelectedIndex = 0; sql msql = new sql("SELECT * FROM Participant ORDER BY 6", "A18_Sim_Eq07"); SqlDataReader read = msql.execute(); while (read.Read()) { cmbGroupesExistants.Items.Add(read["nomGroupe"]); } read.Close(); }
private void PopulerChampsMatériel() { sql msql = new sql("SELECT * FROM ClubDeGo.Materiel ORDER BY 2", "A18_Sim_Eq07"); SqlDataReader read = msql.execute(); while (read.Read()) { cboMateriel1.Items.Add(read["NomMateriel"]); cboMateriel2.Items.Add(read["NomMateriel"]); cboMateriel3.Items.Add(read["NomMateriel"]); cboMateriel4.Items.Add(read["NomMateriel"]); cboMateriel5.Items.Add(read["NomMateriel"]); } read.Close(); }