Hello,

I couldn't download your attached WebApplication1.rar. The link is corrupted.

If it's possible, could you provide the working sample that I can download?

Since I don't have a chinese database, it is difficult for me to run a test based on your scenario.

Therefore, it would be helpful if you can provide a simple working sample (including the database) that replicates your issue.

Thank you.

Regards,

-Martin-

Hi Martin,

the attachment files are the code and the sql server 2005 database.Thanks for your help!

Regards,

gavin

Hello Gavin,

I couldn't find StepName column in the attached sample.

Let me clarify your error. The sorting produces incorrect sorting value when you use WebGrid.

But when you use the same method on other control, it work fine. Is this correct?

However, if you try to sort in the grid without enabling paging, will the sorting value still display incorrectly?

Thank you.

Regards,
-Martin-

Hi Martin,

You can find "BeiZhu" column in the attached sample.

Our own sorting method "GetData" return the correct sorting value in the attached sample when we are using a grid with Classic Paging and Custom Paging Load .But the sorting value display incorrectly.(see the attach picture)

I  sort in the grid without enabling paging, the sorting value still display incorrectly.

Thank you.

Regards,
-gavin-

Hello Gavin,

Regarding this issue, I will need to discuss further with the developer team.

I will let you know when I get the update news from them.

Thank you.

Regards,
-Martin-

Hello,

I've discussed this issue with the developer team.

It is recommended to use either LinqDataSource or ISLinqDataSource in order to sort the data correctly, because WebGrid's sorting is using ASCII code mechanism. Therefore, it might not suitable for your scenario and the sorting will not work perfectly in chinese characters.

If you use LinqDataSource, it will sort the data from the server, not using WebGrid's sorting mechanism.

Hope this helps. Thank you.

Regards,
-Martin-

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-

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-

Hi Martin,

Thank you for your kind reply!

Is there any feedback from your developer team?

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-

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-

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-

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-

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-

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-

0 attachment

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-