//dossier table add , update public void AddDossier(DossierMedical d1) { SqlCommand cmd = new SqlCommand(); string connString; connString = ConfigurationManager.ConnectionStrings["Dbcon"].ConnectionString; SqlConnection sqlConnection = new SqlConnection(connString); sqlConnection.Close(); try { sqlConnection.Open(); cmd.Connection = sqlConnection; cmd.CommandText = "insert into Dossier (IDD,NAME,Etatsante) values('" + d1.idd + "','" + d1.Nom + "','" + d1.EtatSente + "') "; cmd.ExecuteNonQuery(); sqlConnection.Close(); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }
public void editDossie(DossierMedical d1) { SqlCommand cmd = new SqlCommand(); string connString; connString = ConfigurationManager.ConnectionStrings["Dbcon"].ConnectionString; SqlConnection sqlConnection = new SqlConnection(connString); try { sqlConnection.Open(); cmd.Connection = sqlConnection; cmd.CommandText = "update Dossier set NAME='" + d1.Nom + "',Etatsante='" + d1.EtatSente + "')"; cmd.ExecuteNonQuery(); sqlConnection.Close(); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }