title: SELECT into Array
body: <p>I use <code>ExecuteReader()</code>.
  It returns only the last result. I wanted to display the result like an array in <code>tbid_1.Text</code>, <code>tbid_1.Text</code>, <code>tbid_1.Text</code> etc.</p>
  
  <pre><code>    public void Select(FrmVIRGO frm)
                  {
  
                  string query = "SELECT* FROM tb_patient_information ";
                  if (this.OpenConnection() == true)
                  { //Create Command
                      MySqlCommand cmd = new MySqlCommand(query, connection);
                      //Create a data reader and Execute the command
  
  
            MySqlDataReader dataReader = cmd.ExecuteReader();
                          while (dataReader.Read())
                          {
  
  // I think use like this
                         frm.tbid_1.Text = dataReader["id_patient"][1].ToString(); //... id_patient1
                         frm.tbid_2.Text = dataReader["id_patient"][2].ToString(); //... id_patient2
                         frm.tbid_3.Text = dataReader["id_patient"][3].ToString(); //... id_patient3
  
  
                          }
  
                          //close Data Reader
                      dataReader.Close();
  
                      //close Connection
                      this.CloseConnection();
                      }
              }
  </code></pre>