DataAdapter缺失记录

Question

我们使用mySQL对数据读取器(7条记录)执行VB.net语句，然后加载到DataTable (新创建的6条记录？)通过下面的代码--当datatable涉及到第一条记录时--我不知道为什么--我们最欣赏您的智慧。

SQL = "SELECT Count(total) as 'Inv #', CONCAT(DATE_FORMAT(DATE, '%m'), '/', DATE_FORMAT(DATE, '%Y')) AS Month, SUM(total) AS 'Total' FROM (tblinvoices) GROUP BY DATE_FORMAT(DATE, '%m%Y') ORDER BY Month DESC"
                Try
                    myCommand.Connection = MysqlConn
                    myCommand.CommandText = SQL
                    myAdapter.SelectCommand = myCommand
                    myData = myCommand.ExecuteReader()
                    myData.Read()     <- perfect 7 records
                Catch ex As MySqlException
                    MsgBox(ex.Number & ", " & ex.Message)
                Finally
                    Dim MyInvoiced As New DataTable
                    MyInvoiced.Load(myData) <- 6 records???

Answer 1

不用台词就试试吧。

myData.Read()

这是你在第二记录的位置。