I want to sort a dataset and print the results. Reading the forums I deduced that I need to create a dataview and sort it that way. However, when I try to display the results it is not sorted. Here is an example:

Dim dv As New DataView(SelectedRowsDS.Tables(0))

dv.Sort = "transnum ASC"

MsgBox(dv.Table.Rows(0).Item(5) & Chr(13) & _
dv.Table.Rows(1).Item(5) & Chr(13) & _
dv.Table.Rows(2).Item(5) & Chr(13) & _
dv.Table.Rows(3).Item(5))


In my example they are still sorted descending. Any help would be appreciated.