public static void Inserer()
{
Etudiant E = PRL.SaisirEtudiant();
cmd = new OleDbCommand(" Insert into Etudiant values (?,?,?) ", DBconnection.cnn);
cmd.Parameters.Add(new OleDbParameter("NumInscription", E.NumInscription));
cmd.Parameters.Add(new OleDbParameter("Nom", E.Nom));
cmd.Parameters.Add(new OleDbParameter("DateNaiss", E.DateNaiss));
cmd.ExecuteNonQuery();
}
public static Etudiant SaisirEtudiant()
{
Etudiant E = new Etudiant();
Console.WriteLine(" Numero d'inscription : ");
E.NumInscription = int.Parse(Console.ReadLine());
Console.WriteLine(" Nom : ");
E.Nom = Console.ReadLine();
Console.WriteLine(" Date de naissance : ");
E.DateNaiss = DateTime.Parse(Console.ReadLine());
return(E);
}
public static Etudiant GetEtudiant(int numIns)
{
cmd = new OleDbCommand("Select* from Etudiant where NumInscription = ?", DBconnection.cnn);
cmd.Parameters.Add(new OleDbParameter("NumInscription", numIns));
OleDbDataReader rt = cmd.ExecuteReader();
Etudiant etudiant = new Etudiant();
while (rt.Read())
{
etudiant.NumInscription = int.Parse(rt["NumInscription"].ToString());
etudiant.Nom = rt["Nom"].ToString();
etudiant.DateNaiss = DateTime.Parse(rt["DateNaiss"].ToString());
}
return(etudiant);
}