islam negm

islam negm

  • NA
  • 1
  • 0

Searching by describtion

Mar 5 2007 4:23 PM
Hi all I'm using the ms access2003 with the c# i need to search by a describtion of a specific produc in my application now i have to use the LIKE word in my query, but i'm facing a problem of how to pass the parameter of the word after LIKE word I primarily used this SQLQuery "SELECT Med_ID, Med_Name, Med_Backet_Type, Med_Unit_Type, Med_Group, Med_Place, Med_SalePrice, Med_BuyPrice, Med_Backet_qty, Med_Unit_qty FROM Medicine WHERE Med_effect_desc LIKE %?" But there is a syntax error. Thanks

Answers (1)