Data Grid View - Sorting a Text Column That Cotains Dashes

[Auguy]

Does anyone know of a solution for sorting a Data Grid View text column that contains a dash?
This is causing issues because it doesn't match the sort I get from SQL.
I googled some and found somebody that has same issue as me.
The Grid ignores the Dash for sorting.
Is there an option somewhere in .Net that can be set to fix this.

Here is an example.

The Data Grid View sorts like this.e.

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

where I would like:
10-199
10-299
10-399
103-10
103-20


Auguy
Sylvania/Toledo Ohio

 

[strongm]

Odd. I get exactly the result you "would like" in Visual Studio 2019

 

[Auguy]

Thanks, this is an old VS 2008 project.
I've been putting off updating to new version, maybe it's time.


Auguy
Sylvania/Toledo Ohio

 

[Andrzejek]

You may also introduce 2 extra columns: FieldA and FieldB

[pre]
FieldX FieldA FieldB
10-199 10 199
10-299 10 299
103-10 103 10
103-20 103 20
10-399 10 399[/pre]

and in your Select statemt add [blue][tt]Order By FieldA, FieldB[/tt][/blue]

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson