SqlDataReader - Enumeration yielded no results

Question

During execution of this code reader shows "Enumeration yielded no results" and the method return empty model. I have no idea what's wrong

 public UserModel GetUser(string email)
    {
        email = email.ToString();
        var connection = OpenConnection();
        var command = connection.CreateCommand();
        command.CommandText = "select * from Users where UserName = @email;";
        AddParameterString(command, "@email", email);
        SqlDataReader reader = command.ExecuteReader();
        UserModel model = new UserModel();
        while (reader.Read())
        {
            model.ConfirmedEmail = Convert.ToBoolean(reader["ConfirmedEmail"]);
            model.UserId = int.Parse(reader["userId"].ToString());
            model.UserName = reader["UserName"].ToString();
            model.UserEmail = reader["UserEmail"].ToString();
            model.PasswordHash = reader["PasswordHash"].ToString();
            model.PasswordSalt = reader["PasswordSalt"].ToString();
            model.UserRole = reader["UserRole"].ToString();
        }
        return model;
    }
}



 protected void AddParameterString(SqlCommand command, string parameterName, string value)
    {
        var newParameter = command.CreateParameter();
        newParameter.ParameterName = parameterName;
        newParameter.DbType = System.Data.DbType.String;
        newParameter.Value = value;
        command.Parameters.Add(newParameter);
    }

List field names explicitly in select statement. Chances are that some name is mistyped. — Alex Kudryashev
– Alex Kudryashev, Commented Jul 24, 2016 at 17:32
@AlexKudryashev Enumeration yielded no results means that the reader is empty. — Zein Makki
– Zein Makki, Commented Jul 24, 2016 at 18:09
while(reader.Read()) means that OP enter the inner block and at least one row exists. — Alex Kudryashev
– Alex Kudryashev, Commented Jul 24, 2016 at 18:11
@AlexKudryashev The OP never stated that the while block got executed. — Zein Makki
– Zein Makki, Commented Jul 24, 2016 at 19:28
Most probably the error comes from Convert.ToBoolean(reader["ConfirmedEmail"]);. See stackoverflow.com/questions/30600370/… — Alex Kudryashev
– Alex Kudryashev, Commented Jul 24, 2016 at 19:46

elderfo · Accepted Answer · 2016-07-24 18:35:52Z

1

The @ symbol is not required when naming a parameter (see: http://www.dotnetperls.com/sqlparameter)

AddParameterString(command, "email", email);

edited Jul 24, 2016 at 18:35

answered Jul 24, 2016 at 17:23

elderfo

113 bronze badges

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

Comments

Jasmin Solanki · Accepted Answer · 2016-07-25 08:45:51Z

0

AddParameterString(command, "@email", email); // Remove this line

command.Parameters.AddWithValue("@email", email); // Add this line

answered Jul 25, 2016 at 8:45

Jasmin Solanki

4192 gold badges10 silver badges26 bronze badges

Collectives™ on Stack Overflow

SqlDataReader - Enumeration yielded no results

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related