public void editPhotographer(Photographer photogr) { NpgsqlConnection db = DBConnection.Instance.initialize(); NpgsqlCommand cmd_editp = new NpgsqlCommand("UPDATE fotograf SET vorname = @p , nachname = @q , geburtsdatum = @r , notiz = @s WHERE pk_fotograf_id = @t", db); cmd_editp.Parameters.AddWithValue("p", photogr.getVorname()); cmd_editp.Parameters.AddWithValue("q", photogr.getNachname()); cmd_editp.Parameters.AddWithValue("r", photogr.getDate()); cmd_editp.Parameters.AddWithValue("s", photogr.getNotiz()); cmd_editp.Parameters.AddWithValue("t", photogr.getId()); cmd_editp.ExecuteNonQuery(); cmd_editp.Dispose(); }