private void btn_delete_radnik_Click(object sender, EventArgs e) { k = new mysqlController(); k.InsertUpdateDelete("delete from tbl_radnik where id=@id", new MySqlParameter("@id", Convert.ToInt32(txt_radnik_id.Text))); PuniRadnikGrid(); }
private void btn_update_radnik_Click(object sender, EventArgs e) { k.InsertUpdateDelete("update tbl_radnik set ime=@ime, prezime=@prezime, maticni = @maticni, sektorid = @sektorid where id=@id", new MySqlParameter("@ime", txt_ime.Text), new MySqlParameter("@prezime", txt_prezime.Text), new MySqlParameter("@maticni", txt_maticni.Text), new MySqlParameter("@sektorid", combo_sektor.SelectedValue), new MySqlParameter("@id", Convert.ToInt32(txt_radnik_id.Text))); PuniRadnikGrid(); }
private void btn_insert_radnik_Click(object sender, EventArgs e) { k = new mysqlController(); k.InsertUpdateDelete("insert into tbl_radnik (ime, prezime,maticni, sektorid) values (@ime, @prezime, @maticni, @sektorid)", new MySqlParameter("@ime", txt_ime.Text), new MySqlParameter("@prezime", txt_prezime.Text), new MySqlParameter("@maticni", txt_maticni.Text), new MySqlParameter("@sektorid", combo_sektor.SelectedValue)); PuniRadnikGrid(); }