DataView Sort help!

[SeanGrebey]

I'm trying to sort a data table with a data view by a Int64 field. The result I am getting is sorted in chunks. Sort of like:

625
626
627
628
9876301
9876302
9876303
629
630
631

Each "Chunk" is usually at least a couple hundred records, not just two or three. Anybody have anyt thoughts?

Dim dvSortedView As DataView = New _
DataView(m_Dataset.Tables("PMXVendorInfo_AL"))

' Sort the DataView by CG_VEND_NBR
dvSortedView.Sort = "CG_VEND_NBR"

[nemaroller]

dvSortedView.Sort = "CG_VEND_NBR ASC"

I would try explicitly setting ASC on the end.

I assume you tried that though... in which case, this may be a bug.

[cphoenixc]

Are you somehow using a tablestyle for this dataview aswell?
I had loads of troubles sorting a datagrid getting the weirdest results till I noticed that the sorting order in the tablestyle 'wins' from the sorting in the datagrid.
I never set sorting options in the tablestyle, but it then assumes the default values, making changes in the datagrid have no influence at all.

Hope it helps.

[SeanGrebey]

I would try explicitly setting ASC on the end.

Yeah, tried that. thanks though.

Are you somehow using a tablestyle for this dataview aswell?

I'm actually just pulling from an RDB Database, checking for changes, and trying to sort the results and shove them into a SQL Server table, so I don't have any datagrids or any visual components. (Actually, this is a done in a service). Thanks though.