PC Review


Reply
Thread Tools Rate Thread

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

 
 
Justin Dutoit
Guest
Posts: n/a
 
      16th Jul 2003
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


 
Reply With Quote
 
 
 
 
Anders Borum
Guest
Posts: n/a
 
      16th Jul 2003
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.

--
venlig hilsen / with regards
anders borum
--


 
Reply With Quote
 
Justin Dutoit
Guest
Posts: n/a
 
      16th Jul 2003
Thanks for that

Justin

"Anders Borum" <(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
> 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.
>
> --
> venlig hilsen / with regards
> anders borum
> --
>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Field Names: "LongName", "ShortName", "Code", "Description","Comments" PeteCresswell Microsoft Access 2 25th Feb 2009 11:41 PM
<FORM METHOD="post" onSubmit="return fieldcheck()" name="orientation" action="http://ws-kitty.BU.edu/AT/survey/orientation/script/write.asp" language="JavaScript"> Joeyej Microsoft ASP .NET 0 4th Jun 2004 08:55 PM
Manual "Windows Update" produces "ActiveX/active scripting" error message even with "LOW" security level setting in "Trusted" Zone Ray2 Windows XP Help 1 14th Nov 2003 06:50 PM
dr("field").toString returns "400.0000" instead of "400" Dan C Douglas Microsoft ADO .NET 5 22nd Jul 2003 06:48 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:52 AM.