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
| private void CreationRapportVisite_Load(object sender, EventArgs e)
{
try
{
CURS curseurInfosMedocs = new CURS(ChaineConnexion);
string requeteInfosMedocs = "SELECT * FROM medicament ORDER BY MED_NOMCOMMERCIAL";
curseurInfosMedocs.ReqSelect(requeteInfosMedocs);
string medDepot, medNom, medFamCode, medCompo, medEffets, medContreIndic, medPrix, test;
//Double medPrix;
while (!curseurInfosMedocs.Fin())
{
medDepot = curseurInfosMedocs.champ("MED_DEPOTLEGAL").ToString();
medNom = curseurInfosMedocs.champ("MED_NOMCOMMERCIAL").ToString();
medFamCode = curseurInfosMedocs.champ("FAM_CODE").ToString();
medCompo = curseurInfosMedocs.champ("MED_COMPOSITION").ToString();
medEffets = curseurInfosMedocs.champ("MED_EFFETS").ToString();
medContreIndic = curseurInfosMedocs.champ("MED_CONTREINDIC").ToString();
medPrix = curseurInfosMedocs.champ("MED_PRIXECHANTILLON").ToString();
test = "";
test += medNom;
//MessageBox.Show(test);
// create a ComboBox Column
DataGridViewComboBoxColumn dcom = new DataGridViewComboBoxColumn();
dcom.HeaderText = "Médicament";
dcom.Items.Add(test);
//add ComboBox to DataGridView
dataGridView1.Columns.Add(dcom);
//dataGridView1.Rows[0].Cells[0].Value = medNom;
Medicaments unMedoc = new Medicaments(medDepot, medNom, medFamCode, medCompo, medEffets, medContreIndic, medPrix);
lesMedics.Add(unMedoc);
curseurInfosMedocs.suivant();
}
curseurInfosMedocs.fermer();
}
catch (Exception erreur)
{
MessageBox.Show(erreur.Message);
} |
Partager