Beispiel #1
0
 private void BtnRecordToevoegen_Click(object sender, EventArgs e)
 {
     rowProductID = (int)DgvProducten.SelectedRows[0].Cells[0].Value;
     using (invulForm invulForm = new invulForm(this))
     {
         invulForm.Text = "MySQL Databasebeheer - record toevoegen";
         invulForm.RecordtitleLabel.Text = "record toevoegen";
         if (invulForm.ShowDialog() == DialogResult.OK)
         {
             myTable.Rows.Add(new Object[] { rowProductID + 1, productNaam, stock, beschikbaar });
             DgvProducten.Refresh();
             MessageBox.Show("Waarden in datagridview gezet, druk op update om de database te synchronyseren", "INFO", MessageBoxButtons.OK, MessageBoxIcon.Information);
         }
     }
 }
Beispiel #2
0
        private void BtnRecordWijzigen_Click(object sender, EventArgs e)
        {
            rowProductID = (int)DgvProducten.SelectedRows[0].Cells[0].Value;
            using (invulForm invulForm = new invulForm(this))
            {
                if (invulForm.ShowDialog() == DialogResult.OK)
                {
                    myTable.Rows[rowProductID - 1]["productNaam"]  = productNaam;
                    myTable.Rows[rowProductID - 1]["productStock"] = stock;
                    myTable.Rows[rowProductID - 1]["beschikbaar"]  = beschikbaar;
                    DgvProducten.Refresh();

                    MessageBox.Show("Waarden in datagridview gezet, druk op update om de database te synchronyseren", "INFO", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
        }