Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void DodajKsiazkeDoBazy()
- {
- using (var connection = ConnectionHelper.Connect())
- {
- connection.Open();
- var command = connection.CreateCommand();
- PobierzAutora();
- PobierzGatunek();
- PobierzWydawnictwo();
- command.CommandText = "insert into ksiazka (id_ksiazki, tytul, id_autora ,okladka,id_wydawnictwa, opis, ilosc_stron, rok_wydania, isbn, info, id_gatunku) values (ksiazka_sq.nextval," + "'" + aktualna.tytul + "'" + ", " + aautor.id.ToString() + ", " + "'" + aktualna.okladka + "'" + ", " + awydawnictwo.id.ToString() + ", " + "'" + aktualna.opis + "'" + ", " + aktualna.ilosc_stron.ToString() + ", " + aktualna.rok_wydania.Year.ToString() + ", " + "'" + aktualna.isbn + "'" + ", " + "'" + aktualna.info + "'" + ", " + agatunek.id.ToString() + ");";
- MessageBox.Show(command.CommandText);
- var reader = command.ExecuteNonQuery();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement