vb 6.0 searchClosed

Question

I want to search the products from the Product table. using Like Operator i'm not getting it please help

for example i want to search the products having name like P,
all list of P should be shown in MSHflexgrid view ..i 'm not getting the code please help

leo · Answer

dear Sagar,

use a sql querry and try like inspite of using =
here in a sample query for you. check if it is helpful for you.

rs.Open "select * from  [ITEM] WHERE itemname LIKE '%" & Trim(TxtDesc.Text) & "%' ", Temp, adOpenDynamic, adLockOptimistic

Vb 6.0 search

1 response

Similar discussions

Subscribe To Our Newsletter!