示例#1
0
 private void Löschenbutton_Click(object sender, EventArgs e)
 {
     try
     {
         if (Löschen.Text != "")
         {
             string          cmdstr = "DELETE FROM Buchungen WHERE Belegnummer = " + Löschen.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();
             Buchungen a = new Buchungen(r);
             this.Close();
             a.Show();
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.ToString());
     }
 }
示例#2
0
 private void button1_Click(object sender, EventArgs e)
 {
     try
     {
         OleDbCommand    cmd;
         OleDbConnection conn;
         string          cmdstr;
         conn = new OleDbConnection(Properties.Settings.Default.DBSConnectionString1);
         if (combcheck1 && combcheck2 && wertcheck && eadatum && redatum)
         {
             conn.Open();
             //cmdstr = "INSERT INTO Buchungen ([Art], [Ust], [Wert], [Ust-Summe], [Re-Datum], [EA-Datum]) VALUES ('" + Art_cbx.Text + "'," + Ust_cbx.Text + "," + Wert.Text + "," + Ust_Summe.Text + ",'" + Re_Datum.Text + "','" + EA_Datum.Text + "');";
             cmd             = new OleDbCommand();
             cmd.CommandType = CommandType.Text;
             cmd.CommandText = "INSERT INTO Buchungen ([Art], [Ust], [Wert], [Ust-Summe], [Re-Datum], [EA-Datum]) VALUES (?,?,?,?,?,?);";
             cmd.Parameters.AddWithValue("@Art", Art_cbx.Text);
             cmd.Parameters.AddWithValue("@Ust", Ust_cbx.Text);
             cmd.Parameters.AddWithValue("@Wert", Wert.Text);
             cmd.Parameters.AddWithValue("@Ust-Summe", Ust_Summe.Text);
             cmd.Parameters.AddWithValue("@Re-Datum", Re_Datum.Text);
             cmd.Parameters.AddWithValue("@EA-Datum", EA_Datum.Text);
             cmd.Connection = conn;
             //cmd = new OleDbCommand(cmdstr, conn);
             cmd.ExecuteNonQuery();
             conn.Close();
             Buchungen a = new Buchungen(r);
             this.Close();
             a.Show();
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.ToString());
     }
 }
示例#3
0
        private void Buchungen_Click(object sender, EventArgs e)
        {
            Buchungen a = new Buchungen(r);

            a.Show();
        }