MySqlCommand Command.Parameters.Add is obsolete

by

try AddWithValue

command.Parameters.AddWithValue("@mcUserName", mcUserNameNew);
command.Parameters.AddWithValue("@mcUserPass", mcUserPassNew);
command.Parameters.AddWithValue("@twUserName", twUserNameNew);
command.Parameters.AddWithValue("@twUserPass", twUserPassNew);

and don’t wrap the placeholders with single quotes.

string SQL = "INSERT INTO `twMCUserDB` (`mc_userName`, `mc_userPass`, `tw_userName`, `tw_userPass`) VALUES (@mcUserName, @mcUserPass, @twUserName, @twUserPass)";

More Related Contents:

  1. SqlCommand Parameters Add vs. AddWithValue [duplicate]
  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. Assigning out/ref parameters in Moq
  8. Object cannot be cast from DBNull to other types
  9. Default parameter for value must be a compile time constant?
  10. c# Using Parameters.AddWithValue in SqlDataAdapter
  11. How to mark a method as obsolete or deprecated?
  12. How to bind parameters via ODBC C#?
  13. Enable Entity Framework 6 for MySql (C#) in WinForms of Microsoft Visual Studio 2013
  14. Is SqlCommand.Dispose() required if associated SqlConnection will be disposed?
  15. Use of “this” keyword in formal parameters for static methods in C#
  16. Dynamic MySQL database connection for Entity Framework 6
  17. SqlCommand with using statement
  18. Unable to connect to any of the specified mysql hosts. C# MySQL
  19. When is using the C# ref keyword ever a good idea?
  20. MySQL Entity Framework Error – The specified store provider cannot be found in the configuration, or is not valid
  21. Asking for legitimate example of calling stored procedure C#: MYSQL
  22. Using SqlDataAdapter to insert a row
  23. Unity 5.5 obsolete particle system code
  24. Get affected rows on ExecuteNonQuery
  25. Can I have a variable number of generic parameters?
  26. C# params object[] strange behavior
  27. Append values to query string
  28. C# SQL insert command
  29. How can I force a log out of all users for a website?
  30. How do I remove emoji characters from a string?

Leave a Comment