Hi,
I have the following code:
When the DataTable is returned, it is dimensioned correctly for 13 items, but only the [0] index is populated and with the second field [Part Number]. Any ideas on why it's not working correctly?
I have the following code:
OleDbDataAdapter:
conn = new OleDbConnection("Provider=Microsoft.ACE.Oledb.12.0;Data Source='MyAccessDB.accdb';");
conn.Open();
da = new OleDbDataAdapter("SELECT [Date], [Part Number], [Work Center], [Operation #], [Discr 1], [Comm 1], [Problem Code1], [Discr 2], [Problem code 2], [discr 3], [Problem code 3], [discr 4], [problem code 4] FROM RECORDS", conn);
da.Fill(dt);
da.Dispose();
conn.Close();
When the DataTable is returned, it is dimensioned correctly for 13 items, but only the [0] index is populated and with the second field [Part Number]. Any ideas on why it's not working correctly?