I know the DataGridView to display SELECT queries, but, as I understand it, it works only with one table, and if the rows contain references to keys of other tables, then the substitution (Complex query) cannot be done.

Suppose that a complex SQL query is ready (in the TableAdapter), what are the possibilities of displaying the result? And another question, what does the TableAdapter return and how can you handle it with handles?

Thanks in advance for the answers.

    1 answer 1

    I know the DataGridView to display SELECT queries, but, as I understand it, it works with only one table, and if the rows contain references to the keys of other tables, then the substitution (Complex query) cannot be done.

    DataGridView does not work with a single table, but with the result of a single TableAdapter query, be it a complex query, a data presentation query. So you can совершить complex request.