title: How to get the name of tables in a database using GetSchema in vb.net
body: <p>I have the following code.</p>
  
  <pre><code>Dim conn As New MySqlConnection
      Dim command As New MySqlCommand
      Dim dt As New DataTable
      Dim dt1 As New DataTable
      Dim dt2 As New DataTable
      conn.ConnectionString = "server=localhost;userid=root;password=NewPass;database=converter"
      Try
          conn.Open()
          dt = conn.GetSchema("TABLES")
  
          For i As Integer = 0 To dt.Columns.Count - 1
              MsgBox(dt.Columns(i).ToString)
          Next
  
          ComboBox1.ValueMember = "table_name"
          ComboBox1.DisplayMember = "table_name"
          ComboBox1.DataSource = dt
  
          command.Dispose()
          conn.Close()
      Catch ex As Exception
          MessageBox.Show(ex.ToString)
      End Try
  </code></pre>
  
  <p>The values inside the combobox are the names of the tables (there's no problem here). What I want to do is to remove a specific column BEFORE putting it to the combobox. Here comes the problem, I tried displaying the columns inside the dt (datatable) but it does not show the names of the tables. It shows this results.</p>
  
  <ul>
  <li>TABLE_CATALOG</li>
  <li>TABLE_SCHEMA</li>
  <li>TABLE_NAME</li>
  <li>AND SO ON...</li>
  </ul>
  
  <p>How do I get the names of my tables in my dt? Thanks.</p>