I need a RowsCollection to output data from SQL Server. Currently, I sort in

stored procedure, but I would like to sort in my web app. I know a DataView

can be sorted, and that I can get a DataView from a DataSet. I can't seem to

get a RowsCollection from a sorted DataView. I have tried to AppendChanges()

to the source table of my DataView to no avail.



Any thoughts?



Thanks.