C# constructing parameter query SQL – LIKE %

by

You can’t have parameters inside of a string literal in the query. Make the entire value the parameter, and add the wildcards to the string:

var SQL = string.format("SELECT * FROM {0} WHERE {1} LIKE ?", TABLE, NAME);
Cmd.Parameters.AddWithValue(NAME, "%" + "JOHN" + "%");

More Related Contents:

  1. Difference between Parameters.Add(string, object) and Parameters.AddWithValue
  2. Filter sql based on C# List instead of a filter table
  3. Oracle Parameters with IN statement?
  4. problem using Oracle parameters in SELECT IN
  5. Automated checking of database connection and query in same database [closed]
  6. Execute non-query error [closed]
  7. ‘UserControl’ constructor with parameters in C#
  8. How to pass parameters to another process in c#
  9. Validation failed for one or more entities while saving changes to SQL Server Database using Entity Framework
  10. How to bind parameters via ODBC C#?
  11. Wildcard search for LINQ
  12. Map category parent id self referencing table structure to EF Core entity
  13. Use of “this” keyword in formal parameters for static methods in C#
  14. Get an IDataReader from a typed List
  15. Does using parameterized SqlCommand make my program immune to SQL injection?
  16. Entity Framework – stored procedure return value
  17. What’s the fastest way to bulk insert a lot of data in SQL Server (C# client)
  18. Direct method from SQL command text to DataSet
  19. encrypt SQL connectionstring c#
  20. Table name and table field on SqlParameter C#?
  21. How to make LINQ execute a (SQL) LIKE range search
  22. How does C# choose with ambiguity and params
  23. Sql Bulk Copy/Insert in C#
  24. Calling SQL Defined function in C#
  25. Checking for empty or null JToken in a JObject
  26. SQL/C# – Best method for executing a query
  27. Index (zero based) must be greater than or equal to zero
  28. Issues Doing a String Comparison in LINQ
  29. Mapping columns in a DataTable to a SQL table with SqlBulkCopy
  30. SQL connection string for microsoft access 2010 .accdb

Leave a Comment