Vb 6.0 search

sagar - May 4, 2010 at 12:34 AM
 leo - Jun 23, 2010 at 03:17 AM
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

1 response

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