filter datagrid by many criteria
Hi :P
I have a datagridview and i want to filter it by many criteria. I have 3 checkboxes. This is my code:
int value=0;
if (checkBox1.Checked == true)
value = 1;
else if (checkBox2.Checked == true)
value = 2;
else if (checkBox3.Checked == true)
value = 3;
switch (value)
{
case 1:
{
dgv.DataSource = dataSet.Tables["client"].DefaultView;
dataSet.Tables["client"].DefaultView.RowFilter = "denumire LIKE '%" + textBox1.Text + "%'";
break;
}
case 2:
{
dgv.DataSource = dataSet.Tables["client"].DefaultView;
dataSet.Tables["client"].DefaultView.RowFilter = "cuicnp LIKE '%" + textBox2.Text + "%'";
break;
}
case 3:
{
if (comboBox1.SelectedItem.ToString() == "Personal")
{
dgv.DataSource = dataSet.Tables["client"].DefaultView;
dataSet.Tables["client"].DefaultView.RowFilter = "tip_client LIKE 'personal'";
}
}
}
Even though i check 2 checkboxes the dgv is filtered by the first criteria, and to be filtered by both Thanks!