I have a column which displays date and i should sort it in descending order. I order by desc in SQL and fetch the data into dataset. After i apply the datasource grouping is done based on another column. But the sort by desc of date column doesn't sort.

All i need is to sort the date column by desc only once and from then on user is not allowed to sort anything. I have set the AllowSorting option to client side and header click action to SortSingle. Is grouping a problem?

Thanks.,