Howto? Parameters and LIKE statement SQL

by

Well, I’d go with:

 Dim cmd as New SqlCommand(
 "SELECT * FROM compliance_corner"_
  + " WHERE (body LIKE @query )"_ 
  + " OR (title LIKE @query)")

 cmd.Parameters.Add("@query", "%" +searchString +"%")

More Related Contents:

  1. Preventing SQL Injection in ASP.Net
  2. What is the best way to read/parse the XML files [closed]
  3. Generating an Excel file in ASP.NET [closed]
  4. Are Parameters really enough to prevent Sql injections?
  5. An attempt to attach an auto-named database for file ….database1.mdf failed
  6. Is there a way to programmatically determine if a font file has a specific Unicode Glyph?
  7. The transaction manager has disabled its support for remote/network transactions
  8. How can I JSON encode an array in VB.NET?
  9. Images in database vs file system
  10. EF 4.1 exception “The provider did not return a ProviderManifestToken string”
  11. Stopping onclick from firing when onclientclick is false?
  12. How to configure SMTP settings in web.config
  13. IFrame: This content cannot be displayed in a frame
  14. Conversion from type ‘DBNull’ to type ‘String’ is not valid
  15. Editing Web.config programmatically
  16. URL Routing, Image Handler & “A potentially dangerous Request.Path value”
  17. Windows 7 Could not create SSL/TLS secure channel.”} System.Net.WebException
  18. What content type to force download of text response?
  19. How do I give ASP.NET permission to write to a folder in Windows 7?
  20. CustomErrors does not work when setting redirectMode=”ResponseRewrite”
  21. Best way to implement a 404 in ASP.NET
  22. “The system cannot find the file specified”
  23. How to decode viewstate
  24. ASP.NET 2.5 prefixing ctl00 and ASP.NET 4 not prefixing ctl00
  25. How do I attach the debugger to IIS instead of ASP.NET Development Server?
  26. Session would not retain values and always return null
  27. Cache VS Session VS cookies?
  28. What is an HttpHandler in ASP.NET
  29. Asp.Net MVC3, returning success JsonResult
  30. Default redirect for Error 404

Leave a Comment