Hello,
Here is my code so far:
TempCommand.CommandText = "SELECT Lenscode FROM Products WHERE (Lenscode LIKE '%@Input%')"
TempCommand.Parameters.AddWithValue("@Input", "5")
When using a datareader this does not work. but when the code is like this it works:
TempCommand.CommandText = "SELECT Lenscode FROM Products WHERE (Lenscode LIKE '%5%')"
So my question is how can I make this work with the parameters.
Many thanks in advance.
Minko