2 filters on BindingSource no vb

Navigation
1

I have a datagridview of officials and can filter them through the name of each official through this code: 

FuncionariosBindingSource.Filter = "nome like'%" & TextBox1.Text & "%'"

In this same datagridview I have a "year" column that is marked the official entry, I would like to know if I have to filter the name and year of the official. For example in textbox1 type "Joao" and in textbox2 type 2015, there would only be Joao 2015.

Could someone help me?

    
asked by anonymous 23.04.2018 / 14:38

1 answer

1

Good morning Mateus, you will have to create another field to insert the year and in the event that does the search you use the field of the year to filter. There is an example in the link below that is well explained.

link

    
23.04.2018 / 15:17
Select only 1 record per month with an aggravating factor that prevents the use of Group By How to disable Trigger of all tables in PostgreSQL? [closed]