public static void Update(int NumDep, Departement NewD)
{
ProgramMain.bdconx.Open();
string s = "Update Departement set NumDep=" + NewD.NumDep + ",NomDep='" + NewD.NomDep + "',Lieu='" + NewD.Lieu + "' where NumDep=" + NumDep + ";";
SqlCommand cmd = new SqlCommand(s, ProgramMain.bdconx);
cmd.ExecuteNonQuery();
ProgramMain.bdconx.Close();
}
public static void Insert(Departement D)
{
ProgramMain.bdconx.Open();
string s = "Insert Into Departement Values (" + D.NumDep + ",'" + D.NomDep + "','" + D.Lieu + "')";
SqlCommand cmd = new SqlCommand(s, ProgramMain.bdconx);
cmd.ExecuteNonQuery();
ProgramMain.bdconx.Close();
}