❔ Error Message: Microsoft.Data.SqlClient.SqlException: 'Incorrect syntax near 'j'.'
PLEASE HELP!!
Trying to perform search in View Procedure in Sql Server with C# Winform
2 Replies
Please do yourself a favor and remove that SQL string. Read on SQL Injection 🙂
What happens if you select straight from the view?
Also, your SQL statement (the one vulnerable to SQL Injection) can't ever work. It should be
LIKE '%{whatever}%'
. Notice the quotes around the two %s.Looks like nothing has happened here. I will mark this as stale and this post will be archived until there is new activity.