private void button2_Click(object sender, EventArgs e) { dbconnect dbcon = new dbconnect(); String loc = (String)comboBox2.SelectedItem; String qry3 = "SELECT * from inventory_fd where location='" + loc + "' "; BindingSource bsource = new BindingSource(); bsource.DataSource = dbcon.ReadValue(qry3); dataGridView2.DataSource = bsource; }
private void button3_Click(object sender, EventArgs e) { String stadate = dateTimePicker1.Text; String enddate = dateTimePicker2.Text; String loc = (String)comboBox4.SelectedItem; String typ = (String)comboBox3.SelectedItem; dbconnect dbcon = new dbconnect(); String qry1 = "SELECT * FROM fd_trans WHERE location='" + loc + "' AND type='" + typ + "' AND Date BETWEEN '" + stadate + "' AND '" + enddate + "' "; BindingSource bsource = new BindingSource(); bsource.DataSource = dbcon.ReadValue(qry1); dataGridView3.DataSource = bsource; }