title: Binding data in gridview using inner join
body: <p>I am using a mysql database and I am trying to populate the gridview with the inner join query but I can't work it out. Here is my code.</p>
  
  <pre><code>    Sub loadingaccess4()
      Dim adapter As New OdbcDataAdapter("Select customer.CustomerName,   customer.CustomerID from customer INNER JOIN transaction on customer.CustomerID=transaction.CustomerID", dbconn)
      Dim dataset As New DataSet
  
      dataset.Clear()
      adapter.Fill(dataset, "")
      Me.GridView4.DataSource = dataset.Tables(0).DefaultView
      Me.GridView4.DataBind()
  End Sub
  </code></pre>
  
  <p>Can you help me?</p>
  
  <p>Sorry guys, okay I am going to clarify. The gridview shows nothing. Is my code wrong or something?</p>