Resolved Sorting DataGridView

[aaaron]

This seems so simple a question I was sure I could find out myself be reading.
But I haven't.

So I experimented with, for example,
System.String.Compare and System.String.CompareOrdinal

I'm sorting a DataGridView using:
Handles DataGridView1.SortCompare

I want Beatles and BEatles to appear on adjecent rows.

Is that possble?

 

[JohnH]

Do you have an example where you don't get the result you want, and how that should ideally sort?

 

[JohnH]

Generally from Best Practices for Comparing Strings in .NET

Use overloads that explicitly specify the string comparison rules for string operations. Typically, this involves calling a method overload that has a parameter of type StringComparison.

Use string operations that are based on StringComparison.CurrentCulture when you display output to the user.

Which means either StringComparison.CurrentCulture or StringComparison.CurrentCultureIgnoreCase.

 

[aaaron]

Do you have an example where you don't get the result you want, and how that should ideally sort?

Using as something to try:
e.SortResult = System.String.Compare(e.CellValue1.ToString.ToLower, e.CellValue2.ToString.ToLower)
I get:

I got similar results without the ToLower and either System.String.Compare and System.String.CompareOrdinal

I'd like the top and bottom rows next to each other,

 

[aaaron]

Generally from Best Practices for Comparing Strings in .NET

Which means either StringComparison.CurrentCulture or StringComparison.CurrentCultureIgnoreCase.

I Did:

e.SortResult = System.String.Compare(e.CellValue1.ToString, e.CellValue2.ToString, StringComparison.CurrentCultureIgnoreCase)

and got the same as my last post.

 

[JohnH]

That image is sorting on Count, not Artist.

 

[aaaron]

Unbelievable! I hope nobody I know sees this thread.

Thanks