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