C
C#•14mo ago
Pare

❔ 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
Yawnder
Yawnder•14mo ago
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.
Accord
Accord•14mo ago
Looks like nothing has happened here. I will mark this as stale and this post will be archived until there is new activity.
Want results from more Discord servers?
Add your server
More Posts
❔ Having a hard time understanding how external auth providers workI am trying to use Clerk, an auth solution that is similar to Auth0, and I want to add it to my aspn❔ .net web api thread pool sizeI’ve been confused lately about this topic. So acutally, you how many platform threads do we have wh❔ Implement local players using a single button in Windows Forms bowling gameCsharp!!!❔ WPF - Use command of viewmodel instead of item on clickHi, I have a list of strings and display them as buttons. The list is held by a viewmodel and the v❔ Error when deploy a webserviceHello everyone. I'm trying to fix this error when I deploy my app: The configured user limit (128) ✅ Recursive type definitionThis is valid (basically CRTP): ```csharp class Base<T> { } class Derived<T> : Base<Derived<T>> { } ❔ Covariant Interface ReturnIs there some reason why this doesn't work? I understand we can get this behavior with virtual metho❔ WPF Excel Help -I've made an entire post about the problem on C# subreddit. Here's the link to it : https://www.reddHow to do a 3 way merge on a file that has been moved after folder structure and refactoring change?The repo I am working in has been radically refactored. The folder structure has changed and a long ❔ I have a project that I need to submit in 6 hours, but I'm stuck at one point.Project: The project aims to develop a web interface where a minimum of 3 and a maximum of 5 people'