title: select * only return one value
body: <p>I want select multiple (all) values from table Account. </p>
  
  <pre><code>string query = "SELECT * FROM Account";
          SqlConnection connection = new SqlConnection(connectionString);
          SqlCommand command = new SqlCommand(query, connection);
          SqlDataReader reader;
          connection.Open();
          reader = command.ExecuteReader();
          reader.Read();
          label1.Text = reader["PasswordHash"].ToString();
          connection.Close();
  </code></pre>
  
  <p>Why is this always returning only the first row. Actually it return one row, because if I set in where clause something like <code>where id = 2 and id = 3</code> it still returns only one value.
  Table have more than one value i checked form Management Studio, there query run as they should.</p>
  
  <p>Thanks in advance.</p>