Printable View
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"
VB Code:
I would try explicitly setting ASC on the end.
I assume you tried that though... in which case, this may be a bug.
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.
Yeah, tried that. thanks though.Quote:
I would try explicitly setting ASC on the end.
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.Quote:
Are you somehow using a tablestyle for this dataview aswell?