private void btnNuweKliente_Click_1(object sender, EventArgs e) { frmKliente f1 = new frmKliente(myDb, clientID); f1.Show(); this.Close(); }
private void button1_Click(object sender, EventArgs e) { // update die data try { myDb.Open(); string Query = ""; try { OleDbDataAdapter queryAdapter = new OleDbDataAdapter(@"SELECT * FROM Klient WHERE KlientNaam='" + txtName.Text + "'", myDb); Query = "UPDATE Klient SET KlientVan='" + txtSurname.Text + "', KlientTelefoonNommer='" + txtTelefoon.Text + "',KlientNaam='" + txtName.Text + "',KlientKredietwaardig=" + checkBox1.Checked + ", KlientStatus='" + cbStatus.Text + "' WHERE KlientID=" + editID + ""; OleDbCommand cmd = new OleDbCommand(Query, myDb); queryAdapter.InsertCommand = cmd; queryAdapter.InsertCommand.ExecuteNonQuery(); } catch { MessageBox.Show("Vul alle waardes in."); } myDb.Close(); MessageBox.Show("DB Opened"); this.Close(); frmKliente frmBack = new frmKliente(myDb, clientID); } catch (Exception ex) { MessageBox.Show("Error" + ex); } }
private void button1_Click(object sender, EventArgs e) { if (txtName.Text != null) { try { myDb.Open(); dataGridView1.Show(); OleDbDataAdapter queryAdapter = new OleDbDataAdapter(@"SELECT * FROM Klient WHERE KlientNaam='" + txtName.Text + "'", myDb); DataSet ds = new DataSet(); queryAdapter.Fill(ds, "mylist"); dataGridView1.DataSource = ds; dataGridView1.DataMember = "mylist"; myDb.Close(); MessageBox.Show("DB Opened"); frmKliente frmBack = new frmKliente(myDb, clientID); } catch (Exception ex) { MessageBox.Show("Error" + ex); } } if (txtSurname.Text != null) { try { myDb.Open(); dataGridView1.Show(); OleDbDataAdapter queryAdapter = new OleDbDataAdapter(@"SELECT * FROM Klient WHERE KlientVan='" + txtSurname.Text + "'", myDb); DataSet ds = new DataSet(); queryAdapter.Fill(ds, "mylist"); dataGridView1.DataSource = ds; dataGridView1.DataMember = "mylist"; myDb.Close(); MessageBox.Show("DB Opened"); frmKliente frmBack = new frmKliente(myDb, clientID); } catch (Exception ex) { MessageBox.Show("Error" + ex); } } if (txtTelefoon.Text != null) { try { myDb.Open(); dataGridView1.Show(); OleDbDataAdapter queryAdapter = new OleDbDataAdapter(@"SELECT * FROM Klient WHERE KlientTelefoon='" + txtTelefoon.Text + "'", myDb); DataSet ds = new DataSet(); queryAdapter.Fill(ds, "mylist"); dataGridView1.DataSource = ds; dataGridView1.DataMember = "mylist"; myDb.Close(); MessageBox.Show("DB Opened"); frmKliente frmBack = new frmKliente(myDb, clientID); } catch (Exception ex) { MessageBox.Show("Error" + ex); } } if (cbStatus.Text != null) { try { myDb.Open(); dataGridView1.Show(); OleDbDataAdapter queryAdapter = new OleDbDataAdapter(@"SELECT * FROM Klient WHERE KlientStatus='" + cbStatus.Text + "'", myDb); DataSet ds = new DataSet(); queryAdapter.Fill(ds, "mylist"); dataGridView1.DataSource = ds; dataGridView1.DataMember = "mylist"; myDb.Close(); MessageBox.Show("DB Opened"); frmKliente frmBack = new frmKliente(myDb, clientID); } catch (Exception ex) { MessageBox.Show("Error" + ex); } } if (checkBox1.Checked == true) { try { myDb.Open(); dataGridView1.Show(); OleDbDataAdapter queryAdapter = new OleDbDataAdapter(@"SELECT * FROM Klient WHERE KlientKredietwaardig=" + checkBox1.Checked + "'", myDb); DataSet ds = new DataSet(); queryAdapter.Fill(ds, "mylist"); dataGridView1.DataSource = ds; dataGridView1.DataMember = "mylist"; myDb.Close(); MessageBox.Show("DB Opened"); frmKliente frmBack = new frmKliente(myDb, clientID); } catch (Exception ex) { MessageBox.Show("Error" + ex); } } }