Dataview sort problem
Posted on 2006-07-11
I put the results of a running a stored procedure into a dataset. I then created a dataview to be able to sort:
dim dv as new dataview
.table = objDataSet.tables("spResults")
.sort = "ChargeNumber desc"
I load the table into my datagrid. Works fine. sorted and everything. The problem is, I'm trying to load the results into an excel spreadsheet from the dataview but it won't sort.
for dtRow = 0 to dv.count - 1
osheet.cells(3, 1).value = dv.table.rows(dtrow).item("Charge")
and so on
My guess is when I use
it is looking at the first record of the dataview before it was sorted.
How can I change this? I need to go by the sorted order.