1 2 3 4 5 6 7 8 9 10 11
|
OleDbCommand cmd = new OleDbCommand("SELECT employe.matricule, employe.nom, employe.prenom, employe.date_naiss, employe.sexe, employe.tel, employe.bp, employe.ville, employe.nbr_enfant, employe.debut_salaire, employe.fin_salaire, profession.lib_prof, niveau.lib_niveau, nationalite.lib_natio, situation_familiale.lib_situ_fam, profession.code_prof, niveau.code_niveau, nationalite.code_natio, situation_familiale.code_situ_fam, employe.date_naiss, employe.sexe, employe.tel, employe.bp, employe.ville, employe.nbr_enfant, employe.debut_salaire, employe.fin_salaire FROM (((employe INNER JOIN nationalite ON employe.code_natio = nationalite.code_natio) INNER JOIN niveau ON employe.code_niveau = niveau.code_niveau) INNER JOIN profession ON employe.code_prof = profession.code_prof) INNER JOIN situation_familiale ON employe.code_situ_fam = situation_familiale.code_situ_fam", connection);
OleDbDataReader reader = cmd.ExecuteReader();
// Remplir la liste à patir du resusltat de la requete
while (reader.Read() == true)
{
dataGridEmploye.Rows.Add(reader["matricule"], reader["nom"], reader["prenom"], reader["sexe"], reader["lib_prof"], reader["lib_natio"], reader["tel"], reader["ville"], reader["bp"], reader["date_naiss"], reader["lib_situ_fam"], reader["nbr_enfant"], reader["lib_niveau"], reader["debut_salaire"], reader["fin_salaire"], reader["code_prof"], reader["code_niveau"], reader["code_natio"], reader["code_situ_fam"]);
}
reader.Close(); |
Partager