DataView Question

[MikeDamone]

I have a datatable that I am adding rows to on the fly. Then I'm setting the datatable equal to a dataview for sort purposes. Then I want to loop through the sorted dataview and build an html table.

The problem I have is that the row indexes of the dataview table do not reorder when I sort, so the information I'm displaying is out of order. The row indexes remain what they were on the original datatable. Is there a way to loop through using row indexes in a sorted manner? Thanks

 

[Mastakilla]

Wait a sec..

when you say

Then I'm setting the datatable equal to a dataview for sort purposes.

you mean that the dataview.table equals yourDatatable, right?

if:

yourDataview.sort = yourColumnAsstring

doesn't work, you can use an "ORDER BY columnName (ASC or DESC" in your select query.

Hope it's good enough to help you

 

[Mastakilla]

oops,

sure you can't use "ORDER BY" 'cause you're addin' rows on the fly, sorry about that.

 

[mansii]

Just set the dataview:
'dt is your DataTable

Dim dv As New DataView(dt, "Field1 Is Not Null", "OrderField", DataViewRowState.Unchanged)

The dv, consists of all rows in dt whose Field1 is not Null and ordered by the the OrderField.

You can now loop through it:

For Each dr As DataRowView In dv
    'Codes here
Next

Regards,
mansii