Loading

Hello am trying to select data from my database where value

Marvin kakuru

Hello I am trying to select data from my access database where column particulars is like value in my textbox1.text However column particulars in my database is memo data type. This is the code am using but in vain. Select from database where particulars like '%" + textbox.text +"%' Plse any help will b appreciated

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bikesh Srivastava9y ago
Hi,
I think you are doing good ,but you need to change some little bit of code,
can you share your code waht you tried
Nilesh Shah9y ago
I think you are missing a *

in like, either we use ? for one character, or * for more than one characters

Select from database where particulars like '%" + textbox.text +"%'

should be

Select from database where particulars like '*" + textbox.text +"*'