Results 1 to 2 of 2

Thread: [RESOLVED] help filtering 2 columns binding source

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Apr 2010
    Posts
    182

    Resolved [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)

  2. #2

    Thread Starter
    Addicted Member
    Join Date
    Apr 2010
    Posts
    182

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width