title: how to retrieve mysql data in vb.net?
body: <p>im trying to retrieve mysql data with specific column and show to textbox in vb.net. what should i do in retrieving it?</p>
  
  <pre><code>Dim connect As New MySqlConnection("server=localhost; user id=root; password= ; database=ticketing_system;")
      connect.Open()
  
      Dim sqladapter As New MySqlDataAdapter
      Dim sqlcmd As New MySqlCommand
      Dim dr As MySqlDataReader
      Dim dt As New DataTable
  
      sqlcmd = New MySqlCommand("SELECT * complaint WHERE tran_no='" &amp; lbltranno.Text &amp; "'")
      **THEN? WHAT SHOULD I DO TO DISPLAY DATA? PLEASE HELP**
  
      connect.Close()
  </code></pre>