public void PuniSektorCombo() { k = new mysqlController(); combo_sektor.DataSource = k.Datatable("select id, sektor from tbl_sektor"); combo_sektor.ValueMember = "id"; combo_sektor.DisplayMember = "sektor"; }
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_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(); }
public void PuniRadnikGrid() { k = new mysqlController(); grid_radnik.DataSource = k.Datatable("select * from tbl_radnik"); grid_radnik.Refresh(); }