Share via

QueriesTableAdapter

Chris De Smet 0 Reputation points
2024-09-06T11:34:38.4233333+00:00

I have a connection created to a SQL database and I want to run a query from a VS Project.

In the tabelAdapter Query configuration Adapter SELECT which returns a single value is enabled but this gives not the full result of the query. I am sure I need SELECT which returns rows but this option is not enabled. (see attached picture)

The connection to the database works and it I runt the query directly in VS it gives the correct result.

Anybody knows how to enable "SELECT which returns rows"

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.