private void btn_Pridaj_Zamestnanca_Click(object sender, EventArgs e) { SqlConnection MyConn = new SqlConnection(pripojenie); MyConn.Open(); string insert = "insert into Zamestnanec(ID_Zamestnanec,Meno,Priezvisko,Datum_Narodenia,Narodnost,Ulica,Mesto,Pozicia,Telefon,Email,Uzivatel_Username) values (next value for sekZamestnanec,'" + tb_Meno_Zamestnanca.Text + "','" + tb_Priezvisko_Zamestnanca.Text + "','" + dtp_Datum_Narodenia_Z.Text + "','" + tb_Narodnost_Zamestnanca.Text + "','" + tb_Ulica_Zamestnanca.Text + "','" + tb_Mesto_Zamestnanca.Text + "','" + cb_Pozicia_Zamestnanca.Text + "','" + tb_Telefon_Zamestnanca.Text + "','" + tb_Email_Zamestnanca.Text + "','" + cb_Zamestnanec_Uzivatel.Text + "') "; sql = new SqlCommand(insert, MyConn); sql.ExecuteNonQuery(); ds_Zamestnanec.Tables["Zamestnanec"].Clear(); MyAdapter5.Fill(ds_Zamestnanec, "Zamestnanec"); dgw_Zamestnanec.DataSource = ds_Zamestnanec.Tables["Zamestnanec"]; }
private void btn_Zmaz_Zamestnanca_Click(object sender, EventArgs e) { SqlConnection MyConn = new SqlConnection(pripojenie); MyConn.Open(); string delete = "delete from Zamestnanec where ID_Zamestnanec='" + cb_ID_Zamestnanec.Text + "'; " + "delete from Kurier where Zamestnanec_ID_Zamestnanec='" + cb_ID_Zamestnanec.Text + "';"; sql = new SqlCommand(delete, MyConn); sql.ExecuteNonQuery(); ds_Zamestnanec.Tables["Zamestnanec"].Clear(); MyAdapter5.Fill(ds_Zamestnanec, "Zamestnanec"); dgw_Zamestnanec.DataSource = ds_Zamestnanec.Tables["Zamestnanec"]; }
private void btn_Edituj_Zamestnanca_Click(object sender, EventArgs e) { SqlConnection MyConn = new SqlConnection(pripojenie); MyConn.Open(); string update = "UPDATE Zamestnanec SET Meno = '" + tb_Meno_Zamestnanca.Text + "', " + "Priezvisko = '" + tb_Priezvisko_Zamestnanca.Text + "', " + "Datum_Narodenia = '" + dtp_Datum_Narodenia_Z.Text + "', " + "Narodnost = '" + tb_Narodnost_Zamestnanca.Text + "', " + "Ulica = '" + tb_Ulica_Zamestnanca.Text + "', " + "Mesto = '" + tb_Mesto_Zamestnanca.Text + "', " + "Pozicia = '" + cb_Pozicia_Zamestnanca.Text + "', " + "Telefon = '" + tb_Telefon_Zamestnanca.Text + "', " + "Email = '" + tb_Email_Zamestnanca.Text + "', " + "Uzivatel_Username = '******' WHERE ID_Zamestnanec = '" + cb_ID_Zamestnanec.Text + "'"; sql = new SqlCommand(update, MyConn); sql.ExecuteNonQuery(); ds_Zamestnanec.Tables["Zamestnanec"].Clear(); MyAdapter5.Fill(ds_Zamestnanec, "Zamestnanec"); dgw_Zamestnanec.DataSource = ds_Zamestnanec.Tables["Zamestnanec"]; }