There could be one of the following reason why you see your page empty:
1. check the query result after using distinct in your select statement.
(ex. select distinct menu_name from menuinfo)
2. if the query run perfect in query designer, you can check your webpage code and check whether the recordset is recivig the proper query result ? if not then there is prob in query and if yes then there may be some problem in your page code.
debugging the page is the great way to check
still you can give me more details of your code so i can solve it