Q: Case insensitive sorting with DataView

[Jacek]

Hello!

Using a DataView for sorting is quite straightforward, however, I could not
find any way to do case insensitive sort on String column.
I work with multiple languages using UTF-8 encoding in asp.net app. I need
to support culture specific sorting preferences and pogramatically choose
between case sensitive and case insensitive sorting.

any ideas?

Jacek

 

[W.G. Ryan eMVP]

Have you set the Underlying DataTable's .CaseSensitive property?
http://msdn.microsoft.com/library/d...ystemdatadatatableclasscasesensitivetopic.asp
I'm not positive but I think that should do it for you. Remember also that
the dataset has a CaseSensitive property as well and if the datatable is
part of a dataset then it will use that setting by default although you can
override it.

 

[Jacek]

Hi!

Thanks, that fixed the problem. However funny thing is that Underlying table
CaseSensitive property is by default false while DataView will sort without
setting it as it would be true. Strange things happen here.

Cheers

Jacek