Sorting a datagrid with Hyphen / Dash

[Chris Mayers via .NET 247]

Hi,

I have a dotNET Windows Forms DataGrid that contains a column'Part Number'

Problem is when I sort the grid on this column (eitherprogramatically or by clicking on the column header), thesequence is somthing like:

10-199
10-299
103-10
103-20
10-399

ie It seems to ignore the '-'.

Whereas, I want:
10-100
10-200
10-300
103-10
103-20

As the characters before the dash represent the part 'type' andthose after it represent the part 'size'

Is there a way of changing the sort parameters so that it does atrue comparison, rather than making its own decisions about howmy data is formatted...? I really don't want to get intocreating my own DataGrid with customised sort routines etc etcetc if I don't have to...

I don't think the source of the data or the code to generate thedatagrid is relevent, but if anyone believes it is, I canprovide further information on these.

Note: I CAN get round the problem by replacing the '-' with a '~'but that is not really a solution.

Any suggestions gratefully received.

Chris.
CJM170967LAT
--------------------------------
From: Chris Mayers

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>fGtKoxs8HU62/esOXeVmgw==</Id>