Using Prepared Statement in C# with Mysql

by

Try removing ' from your query and use Prepare after adding parameters:

cmd = new MySqlCommand("SELECT * FROM admin WHERE admin_username=@val1 AND admin_password=PASSWORD(@val2)", MySqlConn.conn);
cmd.Parameters.AddWithValue("@val1", tboxUserName.Text);
cmd.Parameters.AddWithValue("@val2", tboxPassword.Text);
cmd.Prepare();

More Related Contents:

  1. Error: You have an error in your SQL syntax – but SQL statement works
  2. Quotes in string [closed]
  3. is there a more efficient way to write this sql code?
  4. Parameterized Query for MySQL with C#
  5. LINQ to Entities does not recognize the method ‘System.String ToString()’ method, and this method cannot be translated into a store expression
  6. How to connect to MySQL Database?
  7. Configuration System Failed to Initialize
  8. ASP.NET use SqlConnection connect MySQL
  9. Most efficient way to insert Rows into MySQL Database
  10. MySqlCommand Command.Parameters.Add is obsolete
  11. LINQ to SQL multiple tables left outer join
  12. Enable Entity Framework 6 for MySql (C#) in WinForms of Microsoft Visual Studio 2013
  13. Dynamic MySQL database connection for Entity Framework 6
  14. C# with MySQL INSERT parameters
  15. Get the id of inserted row using C#
  16. Unable to connect to any of the specified mysql hosts. C# MySQL
  17. Why do I get “System.Data.DataRowView” instead of real values in my WinForms Listbox?
  18. Entity Framework creates a plural table name, but the view expects a singular table name?
  19. MySQL Entity Framework Error – The specified store provider cannot be found in the configuration, or is not valid
  20. Asking for legitimate example of calling stored procedure C#: MYSQL
  21. Using SqlDataAdapter to insert a row
  22. Get affected rows on ExecuteNonQuery
  23. Index (zero based) must be greater than or equal to zero
  24. How to pass a table as parameter to MySqlCommand?
  25. Connection to MySQL from .NET using SSH.NET Library
  26. Testing an Entity Framework database connection
  27. How can I force a log out of all users for a website?
  28. How do I remove emoji characters from a string?
  29. Incorrect string value: ‘\xEF\xBF\xBD’ for column
  30. Could not load file or assembly ‘MySql.Data, Version=6.2.2.0

Leave a Comment