Sorting sql data

bex · March 17th, 2009, 06:36 PM

Hi there

i need to sort data coming from sql 2005,

Code:

<asp:SqlDataSourceID="SqlDataSource1"runat="server"ConnectionString="<%$ ConnectionStrings:ConnectionString %>
"SelectCommand="SELECT [News] FROM [News_table]">
</asp:SqlDataSource>

what will be the best control to use?
i have 2 div tags . div1 and div2
div1 has 5 links:News1, News2, News3, News4, News5.

div2 has a data bind control,Lets say GridView

once the data is displayed a need to be able to sort it by clicking one of the links in the div1,
i know that grid view has sort property that is not what i need the sorting needs to be on the left of the grid,

is that possible?
if not what is the closest match

very similar to members list area in this forum, u have sorting by name, posts, then paging and on top sorting by letters.

thanks