title: Datagridview not showing all records from table
body: <p>Hello my datagridvw shows all records from table minus 1. So my table has 11 rows while my datagridvw shows 10. Is 10 the limit?</p>
  
  <p>Im using VB 2010 its a work project. I have bound columns:PartNbr, Qty(for quantity) and Price. I also have two other columns but I want them hidden. here is code. Hope u can help geniuses</p>
  
  <pre><code>Dim cmd As OleDbCommand = New OleDbCommand("SELECT PartNbr, Qty, Price FROM CompBOM  WHERE HeaderCounter LIKE '" &amp; frmHeader.txtAutoNumber.Text &amp; "' AND LabelName LIKE '" &amp; mbLabel &amp; "'", conn)
      adapter = New OleDbDataAdapter(cmd)
  
      'automatically generates Delete Update Insert Commands for dataadapter object
      Dim builder As OleDbCommandBuilder = New OleDbCommandBuilder(adapter)
      Me.DGView.DataSource = Me.bindingSource
      dataSet = New DataSet()
      adapter.Fill(dataSet, "CompBOMTable")
      DGView.DataSource = dataSet.Tables("CompBOMTable").DefaultView
      conn.Close()
  
  End Sub
  </code></pre>
  
  <p>theres too much other code to include this should suffice</p>