Пример #1
0
        public CreerClient()
        {
            InitializeComponent();
            string structureSql = "SELECT Libelle FROM structures ORDER BY Libelle;";

            Bdd.RemplirLeComboBox(structureBox, structureSql, "Libelle");
        }
Пример #2
0
        public CreerRdv()
        {
            InitializeComponent();

            // On met la date minimum du datepicker à la date d'aujourd'hui
            dateText.DisplayDateStart = DateTime.Now.ToLocalTime();

            remplirCbHoraires(cbHeures, cbMinutes);

            string requeteSqlTypeRdv = "SELECT Libelle FROM typesrdv ORDER BY Libelle;";

            Bdd.RemplirLeComboBox(typeCombo, requeteSqlTypeRdv, "Libelle");
            string requeteSqlInterlocuteur = "SELECT * FROM interlocuteurs ORDER BY Prenom;";

            Bdd.RemplirLeComboBox2Colonnes(interlocuteurCombo, requeteSqlInterlocuteur, "Prenom", "Nom");
        }
Пример #3
0
 public EnvoiMsg()
 {
     InitializeComponent();
     Bdd.RemplirLeComboBox(cb_desti, "SELECT * FROM users WHERE NOT IDUser="******"IDUser"].ToString(), "Mail");
 }