3 tablo var.
ve tablaları kategori cinsinden çağırma yapıyorum:
if (comboBox2.SelectedIndex == 0)
{
try
{
OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=sistem1.mdb");
da = new OleDbDataAdapter("SELECT * FROM sistem WHERE kategori LIKE " + comboBox2.Text + " AND Bina_isim LIKE '" + textBox17.Text + "'", con);
ds = new DataSet();
con.Open();
da.Fill(ds, "sistem");
dataGridView1.DataSource = ds.Tables["sistem"];
con.Close();
}
catch (OleDbException olebexp)
{
Debug.WriteLine(olebexp);
}
}
if (comboBox2.SelectedIndex == 1)
{
try
{
OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=sistem1.mdb");
da = new OleDbDataAdapter("SELECT * FROM fema WHERE kategori LIKE " + comboBox2.Text + " AND Bina_isim LIKE '" + textBox17.Text + "'", con);
ds = new DataSet();
con.Open();
da.Fill(ds, "fema");
dataGridView1.DataSource = ds.Tables["fema"];
con.Close();
}
catch (OleDbException olebexp)
{
Debug.WriteLine(olebexp);
}
}
if (comboBox2.SelectedIndex == 2)
{
try
{
OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=sistem1.mdb");
da = new OleDbDataAdapter("SELECT * FROM haluk WHERE kategori LIKE " + comboBox2.Text + " AND Bina_isim LIKE '" + textBox17.Text + "'", con);
ds = new DataSet();
con.Open();
da.Fill(ds, "haluk");
dataGridView1.DataSource = ds.Tables["haluk"];
con.Close();
}
catch (OleDbException olebexp)
{
Debug.WriteLine(olebexp);
}
}
