Question Queries in the IDE

ulynen

Member
Joined
Feb 18, 2015
Messages
22
Programming Experience
5-10
I may not be in the right place.
I added an mdb file using the add new datasource. this isn't terribly complicated. there are only 3 linked tables and some SQL queries. In the IDE when I display the dataset I can see all the tables but I cannot see any of the queries. Do they get imported when you add a new data source or do you have to manually add them?

uwe
 

JohnH

VB.NET Forum Moderator
Staff member
Joined
Dec 17, 2005
Messages
15,385
Location
Norway
Programming Experience
10+
You have to check "Views" when adding/configuring dataset - this will generate strongly typed tableadapters/tables/rows for the queries in database.
These views will not show up in dataset designer (that only shows local version of db tables and local adapter queries), you can create the objects in code, or drag a view (from Data Sources window) to a form to have them generated in form.
 

ulynen

Member
Joined
Feb 18, 2015
Messages
22
Programming Experience
5-10
I selected views but only the tables show up. The queries don't show at all. and under the tools for dataset everything is dimmed.
 

JohnH

VB.NET Forum Moderator
Staff member
Joined
Dec 17, 2005
Messages
15,385
Location
Norway
Programming Experience
10+
I just tested with a sample Access database that had lots of queries (named 'qrySomething'), and they all showed up under Views in the Data Sources Configuration dialog, I believe these are called 'stored queries'. In Server Explorer I also see some 'qry' items that is listed under Stored Procedures, but these are not available in dataset, I couldn't find VS to support Access SPs in dataset designer.
 

ulynen

Member
Joined
Feb 18, 2015
Messages
22
Programming Experience
5-10
thanks for your help
I guess I have to type the queries in my VB.Net program and execute them. When I open the file in access everything works beautifully. The mdb is set up with ODBC and has 3 tables linked to a MySQL database. I don't manipulate any of those tables. There is a 4th table that gets rebuilt based on a query when the app starts. I run select queries to pick up patient info (a doctor's office) based on the caller id and use the 4th table to get their latest appointment.
Uwe
 
Top Bottom