About add parameter in like statement (in access database- oledbconnection)

Question

User-1122054360 posted

 Hi...I am a new bie in asp.net. Recently face a problem in add parameter in like statement.

Have anyone could tell me, hav any good referrence link or website got introduce this infomation. It is because i quite rush for this, therefore hope anyone can help....

Thanks for viewing and reply.  

Answer 1

User-1171043462 posted

try this out

string strQuery = "SELECT * FROM Table1 WHERE CompanyName LIKE '%' + @CName + '%'";

Answer 2

User-1199946673 posted

mudassarkhan already gave the correct answer, but you could read some more on this here