How to sort order in local language.
i have created a windows database application in .net 2.0..
i am retrieving data from SQL Server 2005 database and displaying in DataGridView.
In DataGrid View i have changed font style of GridViewCell to "Hindi" (a local language).
Now i want to sort DataGridView on basis of Hindi because it is displaying data in hindi, but in database i have english text.
I am using DataGridView sorting but it is sorting only on basis of english text.
How can i sort it on the basis of Hindi text.
thanks in advance...