title: Display MySQL database table data in VB 2010 textboxes
body: <p>I was able to display data from my MySQL table using this code: 
          datardr = cmd.ExecuteReader</p>
  
  <pre><code>    If datardr.HasRows Then
          datardr.Read()
          tb_lname.Text = datardr("SURNAME")
          tb_fname.Text = datardr("GIVEN")
          tb_mname.Text = datardr("MID")
          tb_mi.Text = datardr("MIDDLE")
          tb_app.Text = datardr("APPELLATION")
          tb_prefix.Text = datardr("PREFIX")
          tb_sex.Text = datardr("SEX")
          tb_status.Text = datardr("STATUS")
      End If
  </code></pre>
  
  <p>However, I noticed that it's not displaying all data coming from these fields. I can only view the SURNAME, GIVEN, MID and MIDDLE but the others are not displayed.. I have double checked my database fields and I'm sure that they're the same and without special characters or whitespaces.</p>
  
  <p>Please help. Thanks!</p>
  
  <p>Here is the exact code that I have => <a href="http://pastebin.com/embed_js.php?i=bmBXikXM" rel="nofollow">VB2010 and MySQL Code</a></p>