Intersoft Community - WebDesktop - WebGrid Chinese Sorting Issue

WebGrid Chinese Sorting Issue

MarTin — Wed, 27 Jul 2011 22:41:34 GMT

Hello Gavin,

Let me clarify this property with the developer team.

I will get back to you as soon as possible.

Thank you.

Regards,
-Martin-

WebGrid Chinese Sorting Issue

gavin — Tue, 26 Jul 2011 22:11:33 GMT

Hi Martin,

Thank you for your kind reply!

I had not found the System.Threading.Current.CultureInfo.CurrentCulture. I found a property called System.Threading.Thread.CurrentThread.CurrentCulture property, and I set it to new CultureInfo(“zh-CN”).

System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("zh-CN");
System.Threading.Thread.CurrentThread.CurrentUICulture = new System.Globalization.CultureInfo("zh-CN");

However, chinese sorting issue still exist.Where should the System.Threading.Current.CultureInfo.CurrentCulture should be set?

Thank you.

Regards,
-gavin-

WebGrid Chinese Sorting Issue

MarTin — Tue, 12 Jul 2011 16:41:55 GMT

Hello,

You should use System.Threading.Current.CultureInfo.CurrentCulture. Note that this is not a WebGrid's properties since this issue is related to ISDataSource instead.

Hope this helps. Thank you.

Regards,
-Martin-

WebGrid Chinese Sorting Issue

MarTin — Mon, 11 Jul 2011 18:52:33 GMT

Hello Gavin,

I’m currently still investigating this issue and need more time to provide you with solution, suggestion, or sample. I’ll get back to you as soon as possible.

Thank you.

Regards,
-Martin-

WebGrid Chinese Sorting Issue

gavin — Sat, 09 Jul 2011 01:39:23 GMT

Hi Martin,

Thank you for your kind reply!

Actually we are using ISDS in our project! However, I had not found the CultureInfo.CurrentCulture. I found a property called Culture in the LayoutSettings property, and I set the culture in IntializeLayout(Please see the attached sample).

protected void WebGrid1_OnInitializeLayout(object sender, ISNet.WebUI.WebGrid.LayoutEventArgs e)
{
    CultureInfo culture = new CultureInfo("zh-CN");
    this.WebGrid1.LayoutSettings.Culture = culture;
    this.WebGrid1.LayoutSettings.TextSettings.Language = LanguageMode.UseCulture;
    this.WebGrid1.LayoutSettings.TextSettings.UseLanguage = culture.ToString();
}

However, chinese sorting issue still exist.Where should the WebGrid's CultureInfo.CurrentCulture should be set?

Thank you.

Regards,
-gavin-

WebGrid Chinese Sorting Issue

MarTin — Fri, 08 Jul 2011 03:41:49 GMT

Hello Gavin,

I just get the update from the team.

When using ISDataSource, this issue could be resolved by setting the CultureInfo.CurrentCulture to new CultureInfo(“zh-CN”).

This is already implemented in ISDS, but certainly won’t work in SQLDS or others. But I believe you are using ISDS in your project.

Therefore, please try this suggestion and see how it works on your end.

Hope this helps. Thank you.

Regards,
-Martin-

WebGrid Chinese Sorting Issue

MarTin — Thu, 07 Jul 2011 00:20:39 GMT

Hello Gavin,

Unfortunately, I haven't received any update from them.

Your issue is already queued in our work items. Possibly, it hasn't been processed further due to work items priorities and urgency.

I may be able to help raising the priority for your issue if you can assist me with your license information. Could you let me know if you currently own an active subscription?

Thank you.

Regards,
-Martin-

WebGrid Chinese Sorting Issue

gavin — Wed, 06 Jul 2011 03:22:11 GMT

Hi Martin,

Thank you for your kind reply!

Is there any feedback from your developer team?

We need to fix this soon, kindly help

Thank you.

Regards,
-gavin-

WebGrid Chinese Sorting Issue

MarTin — Tue, 28 Jun 2011 05:19:26 GMT

Hello Gavin,

I'm currently forwarding your issue to the developer team.

I will let you know when I get any feedback from them.

Thank you.

Regards,
-Martin-

WebGrid Chinese Sorting Issue

gavin — Tue, 28 Jun 2011 01:10:23 GMT

Hi Martin,

Thank you for your kind reply!

However, in the large amount of data and flexibility,it is not enough for us to use LinqDataSource or ISLinqDataSource.Such as our queries is not sure sometime, we have many ready-made "GetData" methods , we need to handle large amount of data and so on.
Is there any way to solve the chinese sorting issue when we use ISDataSource having our own sorting method? Or do you have an indirect solution to solve this problem?

We need to fix this soon, kindly help

Thank you.

Regards,
-gavin-

WebGrid Chinese Sorting Issue

gavin — Tue, 21 Jun 2011 03:32:01 GMT

Hi,

We are running a website on Windows 7 Server with China Chinese (zh-CN) culture and having a strange problem while sorting Grid Columns, the details of the problem are as follows,
We are using a grid with Classic Paging and Custom Paging Load.

<LayoutSettings PagingMode="ClassicPaging" PagingLoadMode="Custom" PagingSize="20"  AllowSorting="Yes">
</LayoutSettings>

ISDataSource having our own sorting method "GetData"

<ISDataSource:ISDataSource ID="ISDataSource1" runat="server" SchemaType="CustomObject">
     <Tables>
	<ISDataSource:ISDataSourceTable SelectMethod="GetData" EnablePaging="true"
	    SelectCountMethod="GetCount" TableName="Messages_Center" TypeName="WebApplication1.App_Code.Messages_Center">
	</ISDataSource:ISDataSourceTable>
    </Tables>
</ISDataSource:ISDataSource>

We are experiencing the following behaviour :
When I sort the "StepName" column(contains Simplified Chinese) from A to Z we get the correct value of each page ( see the attach picture) througth "GetData" method.But each page show the value only containing Simplified Chinese incorrectly(see the attach picture).

Do you have any idea on what is causing this behaviour ?We need to fix this soon, kindly help

Thanks