Hi - I am currently moving my website from an existing web server to a new machine.
The new machine is WIN Sever 2003 running IIS6. The site is using ASP.Net 2.
I added the following to the <system.web>
section in my machine.config file to get the website and any future sites to use South African regional settings instead of the default US settings.
<globalization culture="en-ZA" uiCulture="en-ZA"/>
This has mostly worked - the currency symbols have changed from $ to R as they should, but I have a column in a gridview (a bound field - the DB type is money) which is set as follows:
DataFormatString="{0:c}"
[Edit] - have tried this with {0:C} as well as per Richard's suggestion below: still no luck
This is still returning 10000.0000 instead of R 10,000.00 as it was on my old server.
Any ideas as to how to fix this?
Thanks!
[Edit] - I'm beginning to think that this has little to do with the actual culture settings.
I have another form where it works fine:
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Bind("Balance", "{0:c}") %>'></asp:Label>
</ItemTemplate>
The form that doesn't work uses the gridview without a template:
<asp:BoundField DataField="Amount" HeaderText="Amount" SortExpression="Amount" DataFormatString="{0:C}" >
<ItemStyle CssClass="al-r" />
</asp:BoundField>