Search all items in database based on few letters entered in textbox

suchitra

Hi,

I want to display all the items existing in database for ex:

If i enter just book. All the items with book work should get displayed

Example in google search as soon as we enter one word related all things get displayed. I am not talking about auto completion

Mudassar

0 3

You will need to use LIKE Query

SELECT * FROM Table where Column like '%' + 'Private' + '%'

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html