Forms Data Controls :: Populate Gridview In One Page With One Query With Different Status?

I have a gridview with column name:

Pending, Waiters, Opened

and in the rows under column there are figures like:

30, 50, 28
65, 0, 214 etc.

My program is working fine, when I am clicking 30, a new page opens and displays 30 rows, when I click 28 another page opens and displays 28 rows and so on.

In datatable there is a column named Stauts, actually Pending, Waiters,Opened are the status.

In dataset in table adapter I used thress queries one for "Pending", second for "Waiters" and third for "Opened".

To display data I created three pages with gridviews.

I used query like:

Select * from ..... Where status ='Pending'
Select * from ..... Where status ='Waiters'
Select * from ..... Where status ='Opened'

What is Required:

I want to make one query with status =@status and want to use header name in query or in vb.net coding and want to make only one page to display record.

To put my question as an idea/example I used three status but in real scenarion I have lot of status. If I have lot of status so I have to make lot of queries and have to create lot of aspx pages to display data in gridview that is not the correct logic.