Disable Case Sensitive sorting

[Meetu Thomas]

Hi,

My example has the grid grouping control populated with customer details(CustomerId, FirstName, FamilyName, Phone, Email).

If i try to sort the grid by FamilyName and FirstName, i get the result as a case sensitive sort as below

CustomerId	FirstName	FamilyName	Phone	Email
4	Alex	Brown	4541234	[e-mail]
1	Brian	Brown	3423232	[e-mail]
3	Amber	BROWN	4345656	[e-mail]
2	Asmin	BROWN	4587527	[e-mail]

Expected Result

CustomerId	FirstName	FamilyName	Phone	Email
4	Alex	Brown	4541234	[e-mail]
2	Amber	BROWN	4345656	[e-mail]
3	Asmin	BROWN	4587527	[e-mail]
1	Brian	Brown	3423232	[e-mail]

How can i disable the case sensitive sort. Any help is highly appreciated.

Thanks

[Arulpriya Ramalingam]

Hi Meetu, 

 

Thanks for using Syncfusion products. 

 

In order to sort the records with case insensitive, the CustomSortComparer can be implemented from IComparer interface and the Compare() method can be customized to sort the records with case insensitive. The TableControlCellClick event can be used to add the CustomSortComparer at run time. We have modified the sample as per your requirement. Please make use of below code and sample, 

 

Code snippet 

 

SortColumnDescriptor cd; 

#region CustomSort 

public class CustomSortComparer : IComparer 

{ 

    public CustomSort() 

    { 

    } 

    public int Compare(object x, object y) 

    { 

        if (x == null && y == null) 

        { 

            return 0; 

        } 

        else 

        { 

            //To avoid the Case sensitive 

            return ((IComparable)x.ToString().ToLower()).CompareTo(y.ToString().ToLower()); 

        } 

    } 

} 

#endregion 

 

 

Sample link: http://www.syncfusion.com/downloads/support/forum/132070/ze/CaseInsensitiveSorting_(2)-626987763  

 

Regards, 

Arulpriya