Yes, in ASP.NET 2 you can get sorting within a GridView. Works like a charm for me.

But now I want to have one of the columns sorted by default. Even putting "ORDER BY [mycolumnname]" in the SQL query does not help !

You really have to give more info about the context this problem is in, like is this LLBLGen Pro related, do you use SqlDataSource or other object?

Otis wrote:

You really have to give more info about the context this problem is in, like is this LLBLGen Pro related, do you use SqlDataSource or other object?

No no... this is general chat.... not even LLBLGen related this time, just bare-bones GridView ASP.NET 2.0

If you specify an ORDER BY clause in your query then the gridview will automatically be sorted in that order.

You can also use the gridview's build in sort() method eg:

    MyGridView.Sort("Column1, Column2", SortDirection.Ascending);

Jez wrote:

If you specify an ORDER BY clause in your query then the gridview will automatically be sorted in that order.

You can also use the gridview's build in sort() method eg:

    MyGridView.Sort("Column1, Column2", SortDirection.Ascending);

Ehhh...ORDER BY works ???

How... where ? Like so: SelectCommand="SELECT * FROM [ViewClients] ORDER BY EnquiryDate DESC">

in <asp:SqlDataSource does NOT work for me.

I'll go and give the MyGridView.Sort a try.. thanks.

check this out: http://msdn2.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.sort.aspx