title: vb.net/mysql show more then 1 row in TextBox
body: <p>I just started messing around with Visual basic (vb.net) and am trying to show more then 1 database row in a TextBox, so far I have this:</p>
  
  <pre><code>Private Sub foobox_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
  
          Dim conn As MySqlConnection
  
          conn = New MySqlConnection
          conn.ConnectionString = connStr
  
          Try
              conn.Open()
          Catch myerror As MySqlException
              MsgBox("No connection")
          End Try
  
          Dim myAdaptor As New MySqlDataAdapter
  
          Dim sqlquery = "SELECT * FROM foo ORDER BY id DESC"
          Dim myCommand As New MySqlCommand()
          myCommand.Connection = conn
          myCommand.CommandText = sqlquery
  
          myAdaptor.SelectCommand = myCommand
          Dim myData As MySqlDataReader
          myData = myCommand.ExecuteReader()
  
          If myData.HasRows Then
              myData.Read()
              Viewer.Text = myData("foo1") &amp; myData("foo2")
  
          End If
  
          myData.Close()
          conn.Close()
  
      End Sub
  </code></pre>
  
  <p>which connects to a database successfully but but it only outputs 1 row, how can I get it to output more?</p>