Using VS2013 to program a Windows Form application in VB.net.
Created DataSource which links to an Access mdb database:
Tbl_Customers has 8,670 records
Tbl_Invoices has 15,512 records
I can see these results using the Preview Data... function associated with each table in the Data Source. See screenshots at end of post.
Write code to extract data from Tbl_Customers and it returns 8670. PERFECT. Code:
Dim myCustomers As DataTable = On_OrderDataSet.Tbl_Customers
Write duplicate code to extract data from Tbl_Invoices and it returns 0. WRONG! Code:
Dim myInvoices As DataTable = On_OrderDataSet.Tbl_Invoices
What the heck is going on? Why won't this data come through? Please help because it's driving me crazy!