private void cbx_numrap_SelectedIndexChanged(object sender, EventArgs e) { dataGridView1.Rows.Clear(); showItem(); string praticien = ""; string dateRapport = ""; string bilan = ""; string dateVisi = ""; string motif = ""; string praticienRemp = ""; string coef = ""; CURS cs = new CURS(LoginPage.ChaineConnexion); cs.DefFonctStockee("getRapport"); cs.ajouteparametreCol("IdVisiteur", LoginPage.Id); cs.directionparametreCol("IdVisiteur", ParameterDirection.InputOutput); cs.ajouteparametreCol("IdRapport", cbx_numrap.SelectedItem.ToString()); cs.directionparametreCol("IdRapport", ParameterDirection.InputOutput); cs.ajouteparametreCol("idPraticien", praticien); cs.directionparametreCol("idPraticien", ParameterDirection.Output); cs.ajouteparametreCol("dateRapport", dateRapport); cs.directionparametreCol("dateRapport", ParameterDirection.Output); cs.ajouteparametreCol("bilan", bilan); cs.directionparametreCol("bilan", ParameterDirection.Output); cs.ajouteparametreCol("dateVisite", dateVisi); cs.directionparametreCol("dateVisite", ParameterDirection.Output); cs.ajouteparametreCol("idMotif", motif); cs.directionparametreCol("idMotif", ParameterDirection.Output); cs.ajouteparametreCol("idPraticienRemp", praticienRemp); cs.directionparametreCol("idPraticienRemp", ParameterDirection.Output); cs.ajouteparametreCol("coef", coef); cs.directionparametreCol("coef", ParameterDirection.Output); cs.Appelfonctstockee(); txtbox_prac.Text = getPrac(Convert.ToString(cs.getCol()[2].Value)); //string req = "SELECT * FROM `rapport_visite` WHERE `COL_MATRICULE` = '" + LoginPage.Id + "' AND RAP_NUM = '" + cbx_numrap.SelectedItem.ToString() +"';"; //cs.ReqSelect(req); /*while (!cs.Fin()) * {*/ //txtbox_prac.Text = getPrac(cs.champ("PRA_NUM").ToString()); if (Convert.ToString(cs.getCol()[3].Value) == "") { chackDateRap.Checked = false; } else { chackDateRap.Checked = true; datebox.Text = Convert.ToString(cs.getCol()[3].Value); } if (Convert.ToString(cs.getCol()[7].Value) == "") { chackPratRemp.Checked = false; } else { chackPratRemp.Checked = true; txtbox_PraRemp.Text = getPrac(Convert.ToString(cs.getCol()[7].Value)); } tbar_coef.Value = Int32.Parse(Convert.ToString(cs.getCol()[8].Value)); txt_coef.Text = Convert.ToString(cs.getCol()[8].Value); dateVisite.Text = Convert.ToString(cs.getCol()[5].Value); txtbox_motif.Text = getMotif(Convert.ToString(cs.getCol()[6].Value)); richTextBox1.Text = Convert.ToString(cs.getCol()[4].Value); CURS cs1 = new CURS(LoginPage.ChaineConnexion); string med = "SELECT `MED_DEPOTLEGAL`, `OFF_QTE` FROM `offrir` WHERE `COL_MATRICULE` = '" + LoginPage.Id + "' AND `RAP_NUM` = '" + cbx_numrap.SelectedItem.ToString() + "';"; cs1.ReqSelect(med); while (!cs1.Fin()) { CURS cs2 = new CURS(LoginPage.ChaineConnexion); string reqmed = "SELECT `MED_NOMCOMMERCIAL` FROM `medicament` WHERE `MED_DEPOTLEGAL` = '" + cs1.champ("MED_DEPOTLEGAL") + "';"; cs2.ReqSelect(reqmed); while (!cs2.Fin()) { dataGridView1.Rows.Add(cs2.champ("MED_NOMCOMMERCIAL"), cs1.champ("OFF_QTE")); cs2.suivant(); } cs1.suivant(); } cs1.fermer(); }