public void InsertPays(Pays unPays) { Dictionary <string, string> values = new Dictionary <string, string>(); values["id"] = unPays.Id.ToString(); values["nom"] = "'" + unPays.Nom.Replace("'", "\\'") + "'"; mydbal.Insert("pays", values); }
public void InsertFromage(Fromage unFromage) { Dictionary <string, string> values = new Dictionary <string, string>(); values["id"] = unFromage.Id.ToString(); values["pays_origine_id"] = unFromage.Pays_origine_id.ToString(); values["nom"] = "'" + unFromage.Nom.Replace("'", "\\'") + "'"; values["creation"] = "'" + unFromage.Creation.ToString("yyyy'-'MM'-'dd") + "'"; values["image"] = "'" + unFromage.Image.Replace("'", "\\'") + "'"; mydbal.Insert("fromage", values); }
public void Insert(Fromage Unfromage) { Console.WriteLine("INSERT INTO fromage (id,pays_origine_id,nom,creation,image) values (" + Unfromage.Id + ", " + Unfromage.Idpays.Id + ", '" + Unfromage.Nom + "', " + Unfromage.Creation + ", '" + Unfromage.Image + "') ;"); _mydbal.Insert("INSERT INTO fromage (id,pays_origine_id,nom,creation,image) values (" + Unfromage.Id + ", " + Unfromage.Idpays.Id + ", '" + Unfromage.Nom + "', '" + Unfromage.Creation + "', '" + Unfromage.Image + "') ;"); }
public void Insert(Pays Unpays) //insérer une ligne { Console.WriteLine("INSERT INTO pays (id,nom) values (" + Unpays.Id + ", '" + Unpays.Nom + "');"); _mydbal.Insert("INSERT INTO pays (id,nom) values (" + Unpays.Id + ", '" + Unpays.Nom.Replace("'", "''") + "');"); }