private void deletebuttonanlage_Click(object sender, EventArgs e) { try { if (delr == true) { string cmdstr = "DELETE FROM Anlagenverzeichnis WHERE AnlagenverzeichnisID = " + deleteanlagenidbox.Text; OleDbCommand cmd; OleDbConnection conn; conn = new OleDbConnection(Properties.Settings.Default.DBSConnectionString1); conn.Open(); cmd = new OleDbCommand(cmdstr, conn); cmd.ExecuteNonQuery(); conn.Close(); dataGridView1.Update(); Anlagenverzeichnis a = new Anlagenverzeichnis(r); this.Close(); a.Show(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void savebuttonanlage_Click(object sender, EventArgs e) { if (textboxentrue()) { try { OleDbCommand cmd; OleDbConnection conn; string cmdstr; conn = new OleDbConnection(Properties.Settings.Default.DBSConnectionString1); if (textboxentrue()) { conn.Open(); cmdstr = "INSERT INTO Anlagenverzeichnis (Gegenstand, Anschaffungsdatum, Anschaffungswert, Zugang, Dauer, Prozent, Abgang) VALUES ('" + gegenstandbox.Text + "','" + anschaffdatumbox.Text + "'," + anschaffwertbox.Text + "," + Zugangbox.Text + "," + dauerbox.Text + "," + Prozentbox.Text + "," + AbgangBox.Text + ")"; cmd = new OleDbCommand(cmdstr, conn); cmd.ExecuteNonQuery(); conn.Close(); Anlagenverzeichnis a = new Anlagenverzeichnis(r); this.Close(); a.Show(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } }