DataView.Sort int
-
If I have a dataSet and wish to sort it either ASC or DESC by a col - easly done using a dataview. Now if that col contains int's, say 1 - 13 this is where my problem starts. I have noticed this in windows too. create 13 files named 1 - 13 it will sort them in the order 1,10,11,12,13,2,3,4,..... the same seems to be happening to my dataView. Any suggestions as to how to work around this? Tia gadget
-
If I have a dataSet and wish to sort it either ASC or DESC by a col - easly done using a dataview. Now if that col contains int's, say 1 - 13 this is where my problem starts. I have noticed this in windows too. create 13 files named 1 - 13 it will sort them in the order 1,10,11,12,13,2,3,4,..... the same seems to be happening to my dataView. Any suggestions as to how to work around this? Tia gadget
When windows do that for file name,thats because the file names are string and it sort them as string values,so thats correct sorting. DataGrid and DataSet automaticlly detect type of your coluumn and sort them corectlly.Maybe you set 1-13 value as string and it sort them like that,you have to set type of column as integer to get coorect results. Mazy No sig. available now.