private void SearchButton_Click(object sender, EventArgs e)
{
var con = DB.GetSqlkonekcija();
if (odabranabiljka.Text == "____________")
{
BiljkaOdaberi odaberi2 = new BiljkaOdaberi();
odaberi2.Show();
}
else
{
con.Open();
SqlDataAdapter sda = new SqlDataAdapter("SELECT * FROM unos WHERE naziv ='" + odabranabiljka.Text + "'", con);
DataTable dt = new DataTable();
sda.Fill(dt);
opisbox.Text = dt.Rows[0][1].ToString();
combovrsta.Text = dt.Rows[0][2].ToString();
temperatura.Text = dt.Rows[0][4].ToString();
voda.Text = dt.Rows[0][3].ToString();
suhabox.Text = dt.Rows[0][6].ToString();
masnabox.Text = dt.Rows[0][7].ToString();
izgorjelabox.Text = dt.Rows[0][8].ToString();
aknebox.Text = dt.Rows[0][9].ToString();
prehladabox.Text = dt.Rows[0][10].ToString();
bronhitisbox.Text = dt.Rows[0][11].ToString();
astmabox.Text = dt.Rows[0][12].ToString();
upalabox.Text = dt.Rows[0][13].ToString();
zgaravicabox.Text = dt.Rows[0][14].ToString();
nadutostbox.Text = dt.Rows[0][15].ToString();
proljevbox.Text = dt.Rows[0][16].ToString();
zatvorbox.Text = dt.Rows[0][17].ToString();
glavoboljabox.Text = dt.Rows[0][18].ToString();
bolbox.Text = dt.Rows[0][19].ToString();
zuboboljabox.Text = dt.Rows[0][20].ToString();
Byte[] data = (Byte[])dt.Rows[0][5];
MemoryStream mem = new MemoryStream(data);
slikabox.Image = Image.FromStream(mem);
con.Close();
}
}
private void Obrisi_profil_Click(object sender, EventArgs e)
{
var con = DB.GetSqlkonekcija();
if (odabranabiljka.Text == "____________")
{
BiljkaOdaberi odaberi = new BiljkaOdaberi();
odaberi.Show();
}
else
{
con.Open();
SqlDataAdapter sda = new SqlDataAdapter("DELETE FROM unos WHERE naziv ='" + odabranabiljka.Text + "';", con);
sda.SelectCommand.ExecuteNonQuery();
this.Hide();
Profil profil = new Profil();
profil.Show();
BiljkaObrisana biljka = new BiljkaObrisana();
biljka.Show();
}
con.Close();
}
