Displaying Sorted Dataview

[Dman]

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.

[Dmyze]

By Using dv.Table you are accessing the Unsorted table. use:

dv(0)("")
dv(0).Item(5)


Like so:

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

[Dman]

Aaahhhhh...Many Thanks!