Currency,Decima l,Access and Confusion

[MikeY]

Hi Everyone,

I'm trying to extract my pricing from my Access.mdb. Developing WinForm C#.
I've read previous posts on the subject, but I'm still confused.

In Access my "Price" is of "Currency" type. I extract my items
"myDataItem.MyP rice(Convert.To Decimal(myDataR eader["Price"]));

Now my problem like so many others is that if my dollar value is $10.00, and
when I try to extract my data, it converts some how to just "10". How do I
loose the ".00" decimal and the cents? If I have $10.99 value, all is
displayed correctly. Why does this do that, and what do I need to do to
correct this problem. As stated in past posts do I just need to take the
"10" and build a string.Format to rebuild/add the .00 decimal and cents?

Any and all help is appreciated,

MikeY

[Otis Mukinfus]

On Thu, 13 Apr 2006 11:22:11 -0400, "MikeY" <mi*******@yaho .com> wrote:

Hi Everyone,

I'm trying to extract my pricing from my Access.mdb. Developing WinForm C#.
I've read previous posts on the subject, but I'm still confused.

In Access my "Price" is of "Currency" type. I extract my items
"myDataItem.My Price(Convert.T oDecimal(myData Reader["Price"]));

Now my problem like so many others is that if my dollar value is $10.00, and
when I try to extract my data, it converts some how to just "10". How do I
loose the ".00" decimal and the cents? If I have $10.99 value, all is
displayed correctly. Why does this do that, and what do I need to do to
correct this problem. As stated in past posts do I just need to take the
"10" and build a string.Format to rebuild/add the .00 decimal and cents?

Any and all help is appreciated,

MikeY

moneyString = string.Format(" ${0:0.00}", yourDecdimalNum ber);

Good luck with your project,

Otis Mukinfus
http://www.arltex.com
http://www.tomchilders.com

[MikeY]

Hi Otis, Thanks for the response I'll give it a go and see how your syntax
works out.

Thanks again

MikeY

"Otis Mukinfus" <ph***@emailadd ress.com> wrote in message
news:2g******** *************** *********@4ax.c om...

On Thu, 13 Apr 2006 11:22:11 -0400, "MikeY" <mi*******@yaho .com> wrote:

Hi Everyone,

I'm trying to extract my pricing from my Access.mdb. Developing WinForm
C#.
I've read previous posts on the subject, but I'm still confused.

In Access my "Price" is of "Currency" type. I extract my items
"myDataItem.M yPrice(Convert. ToDecimal(myDat aReader["Price"]));

Now my problem like so many others is that if my dollar value is $10.00,
and
when I try to extract my data, it converts some how to just "10". How do I
loose the ".00" decimal and the cents? If I have $10.99 value, all is
displayed correctly. Why does this do that, and what do I need to do to
correct this problem. As stated in past posts do I just need to take the
"10" and build a string.Format to rebuild/add the .00 decimal and cents?

Any and all help is appreciated,

MikeY

moneyString = string.Format(" ${0:0.00}", yourDecdimalNum ber);

Good luck with your project,

Otis Mukinfus
http://www.arltex.com
http://www.tomchilders.com