Parameterized Query for MySQL with C#

by

Try this instead:

private String readCommand = 
             "SELECT LEVEL FROM USERS WHERE VAL_1 = @param_val_1 AND VAL_2 = @param_val_2;";

public bool read(string id)
{
    level = -1;
    MySqlCommand m = new MySqlCommand(readCommand);
    m.Parameters.AddWithValue("@param_val_1", val1);
    m.Parameters.AddWithValue("@param_val_2", val2);
    level = Convert.ToInt32(m.ExecuteScalar());
    return true;
}

More Related Contents:

  1. How do I send generated encrypted password from C# to MySQL
  2. How to connect to MySQL Database?
  3. Configuration System Failed to Initialize
  4. Exception: There is already an open DataReader associated with this Connection which must be closed first
  5. Is it possible to use a MySql User Defined Variable in a .NET MySqlCommand?
  6. .NET Core 2.1 Identity get all users with their associated roles
  7. How to form a correct MySQL connection string? [closed]
  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. Convert DateTime for MySQL using C#
  13. Using Prepared Statement in C# with Mysql
  14. Get the id of inserted row using C#
  15. Why do I get “System.Data.DataRowView” instead of real values in my WinForms Listbox?
  16. Error-Attempt by method ‘X.set_DbConnection(System.Data.Common.DbConnection)’ to access method ‘Y.get_Settings()’ failed
  17. Entity Framework creates a plural table name, but the view expects a singular table name?
  18. Bulk copy a DataTable into MySQL (similar to System.Data.SqlClient.SqlBulkCopy)
  19. MySql Last Insert ID, Connector .net
  20. MySQL C# Text Encoding Problems
  21. Authentication with old password no longer supported, use 4.1 style passwords
  22. Index (zero based) must be greater than or equal to zero
  23. How to call Stored Procedures with EntityFramework?
  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. Could not load file or assembly ‘MySql.Data, Version=6.2.2.0
  30. MySQL C# async methods doesn’t work?

Leave a Comment