title: c# mysql query with select distinct column
body: <p>I am trying to put the DISTINCT rows  (which is a small string) in a string variable targeting a textbox, but it only returns some of the rows with different content in the column. I used similar code but targeting a datagridview and works ok.  I tried different approaches, where am I wrong?</p>
  
  <pre><code>stConsulta = "SELECT distinct symbol from ticks";
  MySqlCommand MyCmd = new MySqlCommand(stConsulta,cnn);
  MyCmd.Connection = cnn;
  MyCmd.CommandText = stConsulta;
  MySqlDataReader myreader = MyCmd.ExecuteReader();
  if (myreader.HasRows)
  {
      while (myreader.Read())
      {
          myreader.Read();
          stSymbols = stSymbols +  myreader.GetString("symbol") + " ";
      }
  }                        
  cnn.Close();
  textBox1.Text = stSymbols;
  </code></pre>