Compare a MySQL column with parameter variable from method

Question

I want to compare the email with the parameter variable also called email. I am getting an error saying "Parameter ?email must be defined" I also tried using @email:

internal bool ValidateUser(string email, string password, bool rememberMe)
{
    bool valid = false;

    using (_msqlCon = new MySqlConnection(_connectionString))
    {
        _msqlCon.Open();
        _query = "SELECT Password, RememberMe FROM RegisteredUsers WHERE Email = ?email";

        using (_command = new MySqlCommand(_query, _msqlCon))
        {
            MySqlDataReader reader = _command.ExecuteReader();
            if (reader["Password"].Equals(password)) { valid = true;  }
        }
    }
    return valid;
}

How can I check if the column Email is the same as the one given as parameter?

jpw · Accepted Answer · 2015-03-10 00:21:14Z

1

If you're asking how you use the email parameter in the query, the answer is that you add it to the command object as a parameter. Try this:

internal bool ValidateUser(string email, string password, bool rememberMe)
{
    bool valid = false;
    using (_msqlCon = new MySqlConnection(_connectionString)) {
        _msqlCon.Open();
        _query = "SELECT Password, RememberMe FROM RegisteredUsers WHERE Email = @Email";

        using (_command = new MySqlCommand(_query, _msqlCon)) {
            _command.Parameters.AddWithValue("@Email", email);
            MySqlDataReader reader = _command.ExecuteReader();

            if (reader["Password"].Equals(password)) {
                valid = true;
            }
        }
    }
    return valid;
}

See the documentation for more information on how to use parameters.

answered Mar 10, 2015 at 0:21

jpw

45k6 gold badges71 silver badges90 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1960836 Over a year ago

Actually my posted solution didn't behave as I expected, so I deleted it. My solution resulted in weird behavior with the MySqlDataReader. So your solution was the one I needed

Collectives™ on Stack Overflow

Compare a MySQL column with parameter variable from method

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related