Member Avatar for markdean.expres

I would like to create a textbox (search engine) that can search for items in a database that contains text as that keyed in the textbox.
I am already aware of this code:
bindingsource.filter = "table Like '" & textbox & "%'"
EX:
what I want is that when I entered "a", all items containing "a" will be displayed like
Apple
Banana
Star Apple


_____
Another thing, I would like to create a search engine that can search for FILES from all folders in the whole computer system. I can only search for files from specified folders...Thanks

  • 3 Contributors
  • 3 Replies
  • 108 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by markdean.expres

Recommended Answers

All 3 Replies

Member Avatar for crapulency

hi. Think you need

fruit LIKE '%a%'

or

fruit LIKe '*a*'


wildcard * or % depends on your database access - Access/sqlserver/oleDB etc. See what works. Substitute "fruit" with the appopriate field name.

Member Avatar for Netcode

Make use of the 'LIKE' wildcard

Edited by Netcode because: n/a
Member Avatar for markdean.expres

THANKS A LOT TO CRAPULENCY!!!!!!!!!!! and to the others who gave a speck of their knowledge. It worked!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.