Query as Datasource for Datagridview: Query not Listed as an Option
Posted on 2008-06-23
In Visual Basic 2008, I have a simple form with a Datagridview control. I have a project dataset in which I have attached perhaps 20 tables from my SqlServer Database. I have made a query that joins 2 tables and there is a query table adapter shown in the dataset explorer, and the query table adapter shows my query, named Lookupvisits(). On the Datagridview, when I click on "choose data source" and I expand the tree structure of my project datasources, the query is not shown. What am I doing wrong? of note, when I click on the query properties, the execute mode property shows 'scalar'- "reader" is not an option, if that matters. Thank you.