static void Main(string[] args)
{
ExamenDAL.GetEtudiant(10);
}
public static void DetailsNotes(int Num)
{
int code = 1;
cmd = new MySqlCommand(" Select m.Intitule,n.DS,n.Examen from module m inner join notes n on m.Code = n.IdModule where IdEtudiant = ?", Connexion.Connect());
MySqlParameter P = new MySqlParameter("IdEtudiant", Num);
cmd.Parameters.Add(P);
MySqlDataReader Lire = cmd.ExecuteReader();
Console.WriteLine(" Code Titre DS Examen Moyenne");
while (Lire.Read())
{
Console.WriteLine(" " + code + " " + Lire["Intitule"].ToString() + " " + Lire.GetDouble("DS") + " " + Lire.GetDouble("Examen") + " " + ExamenDAL.GetMoyenneModule(Num));
code++;
}
Lire.Close();
}
