Thread: Does DataView.ToTable() keep a descending sort order?

My test show both sort orders are preserved.

Ok. Then something must be really strange about my code because when I step through my sorting function I see that the sort direction is "DESC" and then I run the ToTable() function but when I step through the resulting table like this..

Code:

For r As Integer = 0 To dataTable.Rows.Count - 1

            Dim row As DataRow = dataTable.Rows(r)
            ......
Next

...I see that the table still is sorted in an ascending direction.

What could be the explanation for this?

Why do you care about the order of rows in the table? Why not just use the DataView as the data source for your tree view; the rows are coming out in order.

Tables are not suposedto be sortd/have order imposed/relied upon. If you want rows out in a certain order, pull them out of the view, because the view;s job is to perform the ordering

In MVC concept, table is the M and, not the V (view is the V) so by trying to get an M to behave as a V youre using the wrong tool for the job