m_cnBOMConn.ConnectionString = _ "Data Source=KEMI-FJ89SF1\RONSQL;Initial Catalog=BillsOfMaterials;Integrated Security=True" Dim m_Joe As String = "Select * from billsofmaterials.dbo.billoutput" m_daXLRPTadapter = New SqlDataAdapter(m_Joe, m_cnBOMConn) m_daXLRPTadapter.Fill(m_dtXLRPT)
The connection string works and the datatable fill statement works.
m_rows = m_dtXLRPT.Rows.Count()
m_rows does accurately report that the number of records in the datatable is the same as in the SQL table
I can add records to the XLS file with a for/next loop but they are all the first record of the datatable.
So now that I have the data, how do I go through each record sequentially?