populate details view or list view with non empty rows

[code_explorer]

Dear friends, I want to populate a formview or details view or list view in such a way that empty rows will not be displayed at all i.e. suppose there are records in a database having name, age and qualification field. I have some records which do not have age field. I want to populate formview or details view or list view in such a way that for those who have age their records are diplayed alongwith their age. But who don't have, instad of displaying empty fields I do not want to show its row alongwith its label (age) at all. One more thing. How to display multiple records (say 5) in formview or details view or list view alongwith paging (I know paging but don't know how to display particular no of records per page). I will be very much thankful.

[badgrs]

Why not put a WHERE clause in your SQL? WHERE age != null OR age != ''

[code_explorer]

Sir, If I will use that sql query then null age records will not be included in dataset. I just want to eliminate empty rows alongwith their lables in my details or form or list view.