title: selection of data from sqlserver database and display it in datagridview code failed to work
body: <p>am trying to display data from sql database and display it in datagrideview but this code doesn't display column values from the table. the connection is ok and the connection string is working. it does not display any error but it does not work. below is the code am using.</p>
  
  <pre><code>Private Sub TabPage4_load(sender As Object, e As EventArgs) Handles MyBase.Load
      Dim query As String = " SELECT prodt.Name, Types.Type, Types.Kg, Types.Length, Types.Width, Types.Hight, Types.Area FROM prodt,Types WHERE prodt.ProductID=Types.ProductID"
      Dim cm As New SqlCommand(query, conn)
      Dim adapt As New SqlDataAdapter(cm)
      adapt.Fill(table)
      DataGridView1.DataSource = table
  End Sub
  </code></pre>
  
  <p>edited: improved formatting</p>