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();
}
