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();
}