/************************************** tabPage 1 **************************************/
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
if (comboBox1.SelectedIndex == 0)
{
ds = new DataSet();
oda = new OracleDataAdapter("select * from store_products order by id_product", oc);
oda.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
Products.printDataGridTitle(dataGridView1);
}
if (comboBox1.SelectedIndex == 1)
{
ds = new DataSet();
oda = new OracleDataAdapter("select * from store_clients order by id_client", oc);
oda.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
Clients.printDataGridTitle(dataGridView1);
}
if (comboBox1.SelectedIndex == 2)
{
ds = new DataSet();
oda = new OracleDataAdapter("select * from store_distributors order by id_distrib", oc);
oda.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
Distributors.printDataGridTitle(dataGridView1);
}
if (comboBox1.SelectedIndex == 3)
{
ds = new DataSet();
oda = new OracleDataAdapter("select * from store_bookings order by id_booking", oc);
oda.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
Bookings.printDataGridTitle(dataGridView1);
}
}
/************************************** tabPage 2 **************************************/
private void tabPage2_Enter(object sender, EventArgs e)
{
ds = new DataSet();
oda = new OracleDataAdapter("select * from store_products order by name_pr", oc);
oda.Fill(ds);
dataGridView2.DataSource = ds.Tables[0];
Products.printDataGridTitle(dataGridView2);
ds = new DataSet();
oda = new OracleDataAdapter("select * from store_distributors order by title", oc);
oda.Fill(ds);
dataGridView3.DataSource = ds.Tables[0];
Distributors.printDataGridTitle(dataGridView3);
textBox12.Text = DateTime.Today.ToString();
textBox12.Enabled = false;
textBox9.Enabled = true;
textBox9.Text = "";
textBox14.Text = "";
}
