[RESOLVED] help filtering 2 columns binding source
I want to filter 2 columns in binding source o
1.- sucursal by watever is in textsucursal
2.- tipo has more then 7 valuyes..but i want to filter by only 4.. the ones shown in query...
what am i misisng here
Code:
Dim query2 As String = "+'Frascos','Aromaterapia','Perfume Dama','Perfume Caballero'+"
InvPisoBindingSource.Filter = String.Format("Sucursal='{0}' And Tipo Like '{1}' )", textsucursal.Text, query2)
Re: help filtering 2 columns binding source
Code:
InvPisoBindingSource.Filter = ("Tipo IN (" + query2 + ") And Sucursal = " & "'" & textsucursal.Text & "'")
this is wat i did..and i got it..thnk u