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);
}
}
}
