problem with login page in ado.net

string name, password, query;
        name = txtloginname.Text;
        password = txtloginpwd.Text;
        query = "select username,password,trole from userInfo";//userInfo is my table name
        SqlDataReader dr;
        SqlCommand command = new SqlCommand(query, scon);
        dr = command.ExecuteReader();
        while (dr.Read())
        {
            if (name.Equals(dr["username"].ToString()))
            {
                if (password.Equals(dr["password"].ToString()))
                {
                    string role = dr["trole"].ToString();
                    if (role.Equals("STUDENT"))
                    {
                        lblget1.Text = "welcome to" + role;
                    }
                    else
                    {
                        lblget1.Text = "welcome to" + role;
                    }
                }
                else
                {
                    lblget1.Text = "password do not match";
                }
            }
            else
            {
                lblget1.Text = "not a valid user";