DataReader returns Money in format "1,23" instead of "1.23"

[Justin Dutoit]

Hey. I have an OleDBDataReader returning rows from a sql server database.
The column Price is of type money. I bind a datagrid to this
OleDbDataReader, and Prices are in the format "1,23" when in the DB it's
definitely "1.23" ("1,23" formats to "1,23?.??"). I figure some people use
the comma for a decimal place, but I need "." and don't know where to fix
it. Appreciate any ideas!

Tks
Justin Dutoit

 

[Anders Borum]

Try and look into the Globalization namespace. You are probably using a
wrong Localization schema for the application, which result in different
interpretations of e.g. dates and numbers.

 

[Justin Dutoit]

Thanks for that

Justin