private void obrisiPoljeButton_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Trgy\Documents\Visual Studio 2012\Projects\EvidencijaPolja\EvidencijaPolja\BazaPodataka.mdf;Integrated Security=True;"); SqlCommand sc = new SqlCommand("DELETE FROM [Polje] WHERE [PoljeId]='" + PoljaForm.poljeId + "'", con); con.Open(); sc.ExecuteNonQuery(); con.Close(); MessageBox.Show("Obrisali ste polje: " + imePolja); this.Close(); PoljaForm pf = new PoljaForm(); pf.Show(); PoljaForm.poljeId = 0; prinos = 0; cijenaOtkupa = 0; trosakSjemena = 0; trosakGnojiva = 0; trosakSpriceva = 0; trosakGoriva = 0; ostaliTroskovi = 0; dobit = 0; ukupniTrosak = 0; profit = 0; }
private void natragButton_Click(object sender, EventArgs e) { this.Close(); PoljaForm pf = new PoljaForm(); pf.Show(); PoljaForm.poljeId = 0; prinos = 0; cijenaOtkupa = 0; trosakSjemena = 0; trosakGnojiva = 0; trosakSpriceva = 0; trosakGoriva = 0; ostaliTroskovi = 0; dobit = 0; ukupniTrosak = 0; profit = 0; }
private void godinaListBox_MouseDoubleClick(object sender, MouseEventArgs e) { SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Trgy\Documents\Visual Studio 2012\Projects\EvidencijaPolja\EvidencijaPolja\BazaPodataka.mdf;Integrated Security=True;"); SqlDataAdapter sda = new SqlDataAdapter("SELECT [GodinaId] FROM [Godina] WHERE [Godina]='" + godinaListBox.Text + "'", con); DataTable dt = new DataTable(); sda.Fill(dt); DataTableReader dtr = new DataTableReader(dt); while (dtr.Read()) { godinaId = dtr.GetInt32(dtr.GetOrdinal("GodinaId")); } this.Close(); PoljaForm pf = new PoljaForm(); pf.Show(); }