Last post May 09, 2008 10:44 AM by gotdablues
May 09, 2008 10:44 AM|gotdablues|LINK
I am in the process of creating localized ASP.NET 2.0 application. I am new to localization so any help would be appreciated...
The question I have is "How do GridViews, Sorting, Localization and the Database work together?". Let me get a little more specific.
Let say I have a Gridview that does CustomPaging. The Gridview has one column ('Name') and is sortable. I also have custom paging enable for the Grid.
For the CustomPaging, assume I have methods that query the database to populate my VirtualPageCount and retrieves data for the current page. The method that retrieves the data executes a sql statement that only returns the row for the current page (the
query look like SELECT [name] FROM [Customer] ORDER By [name]). My SQL/Server database is setup to use language (English (US)) and Server Collation (SQL_Latin1_General_CP1_CI_AS).
In my browser, I set my culture to en-US. I click the 'Name' column to sort. Everything is sorts correctly. NOW, I change my browser culture to fi (Finish). In Finnish, 'W' and 'V' sort differently than en-US. The database returns the data in the server
collation order. However, the browser need to display in Finnish order.
Any suggestion on how I can have my browser sort correctly when culture is set to Finnish and the Database collation is SQL_Latin1_General_CP1_CI_AS?