If the gridview isn't showing any results, use the debugger to see if:
- results are coming from the database
- the data is correctly binded to the gridview
- necessary columns exist/are created and so on.
If the problem is in the query, start with a simple one and then introduce more conditions to see if they are eliminating all rows.
Based on your description the initial query to test could be something like:
select *
from tbl_user u, tbl_product p
where u.UserId = p.UserId