I forgot to mention:

The regional settings on both the virtual dedicated machine and my test
server here are identical, the code I have uploaded is identical in every
way. However the results are not. When the code is used on my test server I
get '£' (pound) for currency and when the code is used on the virtual
dedicated machine I get '$' (dollar).

I do not believe that my SQL, asp.net, vb.net, database connection string or
my regional settings are in anyway different.

Why do I get '$' sign ?!

-----Original Message-----
From: Philip Steel [mailto:PhilipS@t...]
Sent: 18 September 2002 11:38
To: ASPX_Professional
Subject: [aspx_professional] RE: Format Currency Function


Robert

I suspect this is due to your live web server's global locale settings:
change this to reflect UK and it should solve your issue.

For more info, have a look at this article from 4guysfromRolla.com:

http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=181

Phil

-----Original Message-----
From: Robert Sindall [mailto:rsindall@z...]
Sent: 18 September 2002 11:23
To: ASPX_Professional
Subject: [aspx_professional] Format Currency Function


Hi

I'm using:

Price.Text = String.Format("{0:c}", Products.Price)

Where is the currency formatting set ?

To data coming from a SQL Server 2000 database, the data in the database is
store as datatype Money.

My problem is that on the development machine the £ appears and on the Live
Machine the $ appears.

I need the £ sign. How can I make it appear.

Thanks

Robert


---

ASP.NET 1.0 Namespace Reference with C#
http://www.wrox.com/acon11.asp?ISBN=1861007442

ASP.NET 1.0 Namespace Reference with VB.NET
http://www.wrox.com/acon11.asp?ISBN=1861007450

These books are a complete reference to the ASP.NET namespaces
for developers who are already familiar with using ASP.NET.
There is no trivial introductory material or useless .NET
hype and the presentation of the namespaces, in an easy-to use
alphabetical order ensures a user-friendly reference format.
We provide in-depth coverage of all the major ASP.NET classes,
giving you those real-world tips that the documentation doesn't
offer, and demonstrating complex techniques with simple
examples.

---

---

ASP.NET 1.0 Namespace Reference with C#
http://www.wrox.com/acon11.asp?ISBN=1861007442

ASP.NET 1.0 Namespace Reference with VB.NET
http://www.wrox.com/acon11.asp?ISBN=1861007450

These books are a complete reference to the ASP.NET namespaces
for developers who are already familiar with using ASP.NET.
There is no trivial introductory material or useless .NET
hype and the presentation of the namespaces, in an easy-to use
alphabetical order ensures a user-friendly reference format.
We provide in-depth coverage of all the major ASP.NET classes,
giving you those real-world tips that the documentation doesn't
offer, and demonstrating complex techniques with simple
examples.

---