In sql, i use this query to get contain letter:
select users_id, users_name, users_phone, users_address, users_email from dbo.tblUser where users_name like 'usersname%'
But when i use the same query in c#, i get this:
System.Data.SqlClient.SqlException: ‘Incorrect syntax near ‘%’.’
query in c#:
select users_id, users_name, users_phone, users_address, users_email from dbo.tblUser where users_name like @usersname%
The reason for the error is that you are adding an unknown symbol in your query. There are no quotes around it and also no concatenation is used.
One way to fix that is to add the
% character to the parameter’s value in the c# code. Example:
param.Value = userNameVariable + "%";
WHERE users_name LIKE @usersname
Another option is to concatenate it in the query.
WHERE users_name LIKE @usersname + '%'
WHERE users_name LIKE CONCAT(@usersname, '%')