private void reading() { cmetier.Service service = new cmetier.Service(); MySqlDataReader reader_typeService = service.sendReqInfo(); while (reader_typeService.Read()) { type_service.Add(reader_typeService.GetString(0)); //dgv_service.Rows.Add(reader.GetString(0), reader.GetString(1), reader.GetString(2)); } reader_typeService.Close(); MySqlDataReader reader_nom; MySqlCommand cmd = form_gestion.instance.CreateCommand(); for (int i = 0; i < type_service.Count(); i++) { string req = "SELECT DISTINCT id_salarie, nom, prenom FROM salarie WHERE type_service='" + type_service[i] + "'"; cmd.CommandText = req; reader_nom = cmd.ExecuteReader(); while (reader_nom.Read()) { nom_responsables.Add(reader_nom.GetString(1)); id_responsables.Add(reader_nom.GetString(0)); } reader_nom.Close(); } MySqlDataReader reader = service.sendReqInfo(); int cpt = 0; int cpt_resp = nom_responsables.Count(); while (reader.Read()) { dgv_service.Rows.Add(reader.GetString(0), reader.GetString(1)); if (cpt < cpt_resp) { //nom_responsable.Items.Add(nom_responsables[cpt]); } cpt++; } reader.Close(); }
public List <cmetier.Service> sendReqInfo() { string req = "select * from service"; MySqlCommand cmd = form_gestion.instance.CreateCommand(); cmd.CommandText = req; MySqlDataReader reader; reader = cmd.ExecuteReader(); cmetier.Service service; List <cmetier.Service> list_service = new List <cmetier.Service>(); while (reader.Read()) { String type_service = reader.GetString(0); String libelle_service = reader.GetString(1); service = new cmetier.Service(type_service, libelle_service); list_service.Add(service); } reader.Close(); return(list_service); }