I have created a new thread (with sample code) here that indicates the problems I am having with cultureinfo in WebInput and WebGrid.

Regarding #3 above, if I set the CultureInfo on the control, but leave cultureinfo alone on the current thread, the "value" stored in the controls should be stored in the "thread" culture. If I am entering "1,2" in the grid or webinput control, the value should be "1.2".

Your issue is under investigation, we need to further discuss with our developer teams. So, I hope you can be patient while waiting for the solutions.

Regards,

Hendrik

Any new information regarding this issue?

Hi Frank,

Until now, we are still trying to find the solutions for this issue , please be patient.

Regards,

Hendrik

Any progress on this?

Any progress on this?

Any progress on this?

Apologize for the delay in sending this.
This problem has been forwarded to the development team. It is filed under work item #1077.

I will keep you updated with any news I heard from the team regarding work item #1077.

Any progress on this?

How do I research progress for "work item #1077"?

Work item #1077 is on progress.
I will let you know when the nightly-build hotfix (pre-release hotfix) is ready to be evaluated.

Great news. We'd like to get this in our next release.

Any progress on this?

I enclose a sample of WebGrid based on the initial requirement of this thread. The detail is listed below.

• The machine has a customized format for displaying currency or numbers. The CurrencySymbol is set as “£”; NumberDecimalSeparator, CurrencyDecimalSeparator, and PercentDecimalSeparator respectively is set to “,”; NumberGroupSeparator, CurrencyGroupSeparator, and PercentGroupSeparator respectively is set to “.”.
• When user enters “3,4”, it should be stored in the database as “3.4”.

During AddPendingChanges client-side event of WebGrid, we need to manipulate the NewValue property of rowChange into the format accepted by WebGrid. After the changes are saved, we need to refresh the grid’s data on AfterResponseProcess.

Please have the sample evaluated on your end and let us hear your feedback.

I have not yet tested this completely, but we will need the same functionality for WebInput fields of decimal type, too.

What are the functional equivalents to "AddPendingChanges", "rowChange", and "AfterResponseProcess".

I have not yet tested this completely, but we will need the same functionality for WebInput fields of decimal type, too.

What are the functional equivalents to "AddPendingChanges", "rowChange", and "AfterResponseProcess".

Please forgive me for lack of understanding about the terms quoted above.

Do you mean that you would like to have functional equivalents to "AddPendingChanges", "rowChange", and "AfterResponseProcess" over WebInput control or over the "UnitPrice" column of WebGrid?

If i have a form using a webinput control (type=decimal) and need to apply the same functionality.

What are the methods that provide the functionality for a webinput that are provided by "AddPendingChanges", "rowChange", and "AfterResponseProcess" on the webgrid?

The AddPendingChanges mark changes to WebGrid’s row and add it into pending changes collection. It is one of WebGridRow method which is related to BatchUpdate feature of WebGrid. There is no such functionality in WebInput since WebInput doesn’t has the batch update feature.

The rowChange is one of the parameters contained in OnAddPendingChanges and OnRemovePendingChanges. These client side events are fired when a pending changes is about to be added or removed. This one also related to BatchUpdate feature of WebGrid, so there will be no same functionality over WebInput control.

The AfterResponseProcess, specifically OnAfterResponseProcess, specifies the client side (JavaScript) function that will be invoked after the response action of a request has been performed. The client event that has the same functionality in WebInput control is probably the OnAfterValueChanged. It is specifies the client side (JavaScript) function name that will be invoked when control state is changed. Parameters: controlId, newValue, newText.

Hope this helps.

Do you have a list of available client side events available for the WebGrid and WebInput controls?

To find list of available client side events of WebGrid, please do the following.

1. Open WebGrid 7 Documentation (start > All Programs > Intersoft WebUI Studio 2011 R2 SP1 > WebUI Studio for ASP.NET > WebGrid 7 > WebGrid 7 Documentation).
2. Using the left side of Content Navigation, browse through Help Viewer Home > WebGrid > Server-side References > ISNet.WebUI.WebGrid assembly > ISNet.WebUI.WebGrid Namespace > ClientEvents Class > ClientEvents Class Members.

To find list of available client side events of WebInput, please do the following.

1. Open WebGrid 7 Documentation (start > All Programs > Intersoft WebUI Studio 2011 R2 SP1 > WebUI Studio for ASP.NET > WebInput 4 > WebInput 4 Documentation).
2. Using the left side of Content Navigation, browse through Help Viewer Home > WebInput > Server-side References > ISNet.WebUI.WebInput assembly > ISNet.WebUI.WebControls Namespace > WebInput ClientSideEvents Class Members.

Hope this helps.

OK, so finally getting around to testing this fully.

It seems to work for display and edit, but when I enter "12", then click "Accept All Changes", the grid is refreshed with "£1.200,00" in the cell I just updated.

When I enter "1,4", then click "Accept All Changes", the grid is refreshed with "£140,00" in the cell I just updated.

When I enter "12.999,45", then click "Accept All Changes", the grid is refreshed with "£1.299.945,00" in the cell I just updated.

This is not the expected behaviour in any example.

When I review the properties for WebGrid1 after assignment in "WebGrid1_OnAfterResponseProcess", the properties for  WebGrid1.CultureInfo.NumberFormatInfo.Decimal do not appear to be set correctly (see attached).

The sample attached in my previous post (posted on January 16, 2012 2:32 AM) contains workaround which handles the data saving operation in OnAddPendingChanges client side event.

After re-test the scenario, it was found that the workaround is no longer needed. Please try to removes OnAddPendingChanges client side event and let us know if you have different result.

Before:

<ISWebGrid:WebGrid ID="WebGrid1" runat="server" ...>
    <LayoutSettings ...>
        <ClientSideEvents OnAddPendingChanges="WebGrid1_OnAddPendingChanges" OnAfterResponseProcess="WebGrid1_OnAfterResponseProcess" />
    </LayoutSettings>
    ...

After:

<ISWebGrid:WebGrid ID="WebGrid1" runat="server" ...>
    <LayoutSettings ...>
        <ClientSideEvents OnAfterResponseProcess="WebGrid1_OnAfterResponseProcess" />
    </LayoutSettings>
    ...

When I use  a web service for the update, the value entered in the grid is sent to the service as "12,44" when I expect a value of "12.44". The behavior is not correct.

Please see the attached example and solve these issues:

1. Updating does not occur when a change is made to "UnitPrice". An error is returned from the IS javascript.
2. Using the cultureinfo does not work in edit mode.
3. Verify the value passed to the "SaveOrderDetails" method contains a string value, not a numeric value.
4. Verify the value passed to the "SaveOrderDetails" method contains an invalid value when cultureinfo is modified. (12,44 instead of 12.44)

Thank you.

Thank you for the sample.However, I was unable to open/download the sample. The attachment link returns http 404: not found. Please try to re-attach the sample so that we can assist you further.

Try this one (I removed the old to avoid any confusion).

You will need to add your own northwind.mdf file in the app_data folder.

Yudi,

Does the new sample work and are you able to see the problem?

Thanks.

Sorry for the delay in sending this.

Thank you for the sent sample. I was able to reproduce the reported problem using the new sample.

I will have this forwarded to the development team and will inform you the result.

Thank you and have a nice day.