dimanche 16 février 2020

Rowfilter and checkbox with access #C

I would like to filter an ms access database and have a preview in a DataGridView. Actually, i'm able to filter with combobox or textbox like this :

dvhotline.RowFilter = "Quand LIKE '%" + textBox1.Text + "%' AND Qui LIKE '%" + textBox2.Text + "%' AND Quoi LIKE '%" + textBox3.Text + "%' AND Pb LIKE '%" + textBox5.Text + "%' AND Solutions LIKE '%" + textBox4.Text + "%' AND Statut LIKE '%" + comboBox1.Text + "%' AND Axi = '%"+checkBox1.Checked+"%' ";

But i have a collumn with checkbox true/false.

How can I filter with a checkbox like (I know it's false but it's my only idea) :

...AND Collumnname LIKE '"+checkbox1.checked+"'

Thank you ;)




Aucun commentaire:

Enregistrer un commentaire