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

  • Thread starter Thread starter Justin Dutoit
  • Start date Start date
J

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
 
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.
 
Back
Top