Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Foriegn Currency formatting problem

Status
Not open for further replies.

777axa

Technical User
Jul 30, 2002
48
US
I'm non-english using win2k with asp.net and MS SQL server7.
I changed regional settings in windows for US (currency, delimiters & others)
If I use currency formatting {0:C} to pull out data & dislpay it in the textboxes of the datagrid control I'm getting non-US currency (russian in my case), so the price looks like : 34,55 p. instead of $34.55
In order to update the price you have to type in something like 34.55 otherwise comma and p. from the textbox mess up the SQL string and update fails (no error though)

Can anybody tell me if there are more places in win2k for tweaking currency settings or any functions in asp.net for overriding those settings?

Thank you very much
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top