I’m not sure if I understand what your problem is?
If by “executing” the statement you mean to call Exec() on the statement, then yes, you do not get any database items back, as Exec() is meant for write operations.
If you want to read, then you use QueryRow() and iterate over the result set until it is empty.