title: Why is ExecuteReader only giving me 1 row of data back?
body: <p>I have this code and its only returning the first string [0] and errors on the rest of them saying the index is out of the array which means only 1 row is getting pulled BUT I DON'T KNOW WHY!!!</p>
  
  <pre><code>MySqlConnection connection = new MySqlConnection(MyConString);
  MySqlCommand command = new MySqlCommand("SELECT email_address FROM account_info", connection);
  MySqlDataReader reader;
  
  try
  {
  
      connection.Open();
      reader = command.ExecuteReader();
       if (reader.HasRows)
      {
          while (reader.Read())
          {
              textBox1.Text = reader[0].ToString();
  
              textBox2.Text = reader[0].ToString();
  
              textBox3.Text = reader[0].ToString();
          }
  
  
          reader.Close();
      }
  </code></pre>