>Let me clarify...
>
>Allow the user to sort (ascending/descending) by clicking on the column header. Provide a visual clue as to how the sorting is done in the column header. Do this without round tripping to the server.
>
>Now do the same thing, but with grouping and provide an indicator in the grid where one group ends and another begins.
>
>
>>SELECT * FROM MyTable ORDER BY... GROUP BY
>>
>>How did you do this without WPF? I've done it a few different ways. Surely you're not advocating that there was no way to do this before WPF?

Sort the dataset. I already do this. or use a listview. Sorting & UI cue already there.