hi all,

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...

Hi, I think the easiest way is to get the data from the database sorted in the Hindi rules by using a collation.
http://msdn2.microsoft.com/en-us/library/ms188385.aspx
http://msdn2.microsoft.com/en-us/library/ms184391.aspx

Greetz,

Geert

http://geertverhoeven.blogspot.com

hi geert,

thanx for your reply...
collation works only if i have unicode (hindi text) values in database but in my case..i am storing english text in Database...but i have just changed the font of Cell in DataGridView.....so in DataGridView it is showing hindi....so do we have any way to sort our DataGridView on the basis on hindi text....

looking forward for your reply....