Sorting using Dropdownlist with Gridview

Hello FRNDS, Please solve my problem facing with GRIDVIEW AND DROPDOWNLIST.

Am working on ASp.NET, c#, SqlSERVER2005.

On my webpage I have a Dropdownlist and a Gridview...data is dispalying perfectly from database. and this gridview contains PAGING ALSO(it contains Large number of records in GRIDVIEW) and the thing here is I need to sort the data based upon dropdown.

It should sort the complete column when selected from dropdownlist item.

In dropdownlist I used items as
1)sort by Employee name ---This must be sort alphabetwise A-Z
2)Sort by Hiring Date ---- Ascending order
3)Sort by Terminating Date --- Ascending Order.

When i select one item from Dropdownlist, that particular column must sort in Gridview.


Please help me, and solve this problem.

THANKS IN ADVANCE.

Tags: ASP.NET, Gridview, Sorting, Drop-down, Paging