Anybody have any experience using dataviews and sorts? I'm trying to sort some data in a datatable before I write it out to SQL Server based on an Int64 column, and it seems like my data is coming out sorted, but only in blocks (SEE BELOW). My sort looks like:
' Sort the DataView by CG_VEND_NBR
dvSortedView.Sort = "CG_VEND_NBR ASC"
Where CG_VEND_NBR is an Int64. My data is coming out as follows. Any thoughts.
608
609
610
611
612
9999989100
9999990300
9999991200
9999992100
9999992900
9999995501
614
615
616
618
619


Reply With Quote