I have a dataset (GrindItems) with 4 datatables successfully populated from dbf files. If I understand the concept of a dataset, I no longer need an open connection to the source db and I should be able to query my dataset.
My first question is whether I need a Connection string OR can I just do this through a dataadapter OR whether I need both?
If I need a connection string ....what kind...example?
I need to query these tables with a UNION query and output query to a 5th datatable.
Is that a problem with datasets?
Here's the query and it works in Access with no problems
Dim mySQL As String mySQL = "SELECT GNDSALE.UNIT, venue.StoreName, GNDSALE.DOB, GNDSALE.PERIOD, PRD.NAME, GNDSALE.TYPE, GNDSALE.TYPEID, TDR.NAME, GNDSALE.AMOUNT" & _ "FROM (venue INNER JOIN (TDR INNER JOIN GNDSALE ON TDR.ID=GNDSALE.TYPEID) ON venue.ID=GNDSALE.UNIT) INNER JOIN PRD ON GNDSALE.PERIOD=PRD.ID" & _ "WHERE(((GNDSALE.TYPE) = 4))" & _ "ORDER BY GNDSALE.TYPEID"
Thanks for your assistance