Problems sorting dataview

[CookieMonster24]

I'm having problems sorting my dataview. If anyone could help that would be great. here is what i have

 

(dt is my datatable)

 

Dim dv As New DataView(dt, "", "", DataViewRowState.CurrentRows)

dv.Sort = "ClientID"

PrintTable(dv.table, "DataTable") ' using this to test the sort

'then i would like to replace my current datatable with what i just sorted

 

i've also tried just sorting like this

dt.defaultview.sort = "ClientID"

but that still doesn't work.

 

Private Sub PrintTable(ByVal t As DataTable, ByVal label As String)

' This function prints values in the table or DataView.

Console.WriteLine("\n" + label)

Dim row As DataRow

Dim c As DataColumn

For Each row In t.Rows

For Each c In t.Columns

Console.Write("\t{0}", row©)

Next c

System.Console.WriteLine("")

Next row

Console.WriteLine()

End Sub

 

Any ideas where i am going wrong?

[PlausiblyDamp]

By refering to the table property you are looking at the original unsorted table. If you databind to the dataview that will display sorted data, IIRC programatically you should be looking at the DataView's Item property.

[BlueJay924]

How would i go about doing this?

 

By refering to the table property you are looking at the original unsorted table. If you databind to the dataview that will display sorted data' date=' IIRC programatically you should be looking at the DataView's Item property.[/quote']

[Nerseus]

Offhand, you'll need a new function PrintDataView that accepts a DataView instead of a DataTable. Then loop through a DataRowView collection instead of the Rows.

 

You might change your PrintTable to be more generic, but since it looks like test code I'd just use two functions.

 

-nerseus