Hi!
With two comboboxes I need to make filter from one database column.
I wrote these codes to facilitate me to make filter between a couple of numbers. For instance, display number between 3 to 8.
I do try to write these codes but its doesnt works. Please have a look:
private void picBxAgeCons_Click(object sender, EventArgs e)
{
conn.Open();
OleDbCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from myDataBase where (Age between ? and ?)";
var param1 = new OleDbParameter("@StartAge", OleDbType.Numeric);
var param2 = new OleDbParameter("@EndAge", OleDbType.Numeric);
param1.Value = cbxAgeStart.Text;
param2.Value = cbxAgeEnd.Text;
if (cbxAgeStart.Text <= cbxAgeEnd.Text)
{
cmd.Parameters.Add(param1);
cmd.Parameters.Add(param2);
}
else
{
cmd.Parameters.Add(param2);
cmd.Parameters.Add(param1);
}
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
da.Fill(dt);
conn.Close();
dgvIdadeCons.DataSource = dt;
this.dgvIdadeCons.RowsDefaultCellStyle.BackColor = Color.AliceBlue;
this.dgvIdadeCons.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige;
}