/************************************** 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 = ""; }