Simple Convert String to Decimal with 2 places to the right.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pvong - 03 Oct 2007 02:56 GMT

Newbie learning VB.Net.

I have a simple DataReader and I can grab the info. The data is in numeric
format like 123.99 and I want a TextBox to just display it just like that.
When I use the code below, I get 123.9900 and I don't know how to get rid of
the last 2 zeros. I thought for sure the below would work but it didn't.
Thanks in advance.
----------------------
Dim AmountMoney As Decimal = CType(dr.Item("Amount"), Decimal)

AmountTB.Text = AmountMoney.ToString

Reply to this Message

Martin CLAVREUIL - 03 Oct 2007 06:42 GMT

Hi,

The 'string ToString(string format)' method allready provides the same
fonctionality. In C# it looks likr this :

decimal d = (decimal)123.9900;
Console.WriteLine(d.ToString("N2"));

pvong write :

> Newbie learning VB.Net.
>
[quoted text clipped - 7 lines]
>
> AmountTB.Text = AmountMoney.ToString

Reply to this Message

RB - 03 Oct 2007 11:41 GMT

Reading between the lines of your question, and in addition to Martin's
answer, it looks like you are getting a field from a database, which has
been declared as "money", and you want to display it as a currency.

Firstly, a lot of people don't use the "money" datatype, and instead use
something along the lines of "decimal (12, 2)", as they find it easier
to work with - google about why the money datatype is evil will get lots
of argument (for and against!!)

Secondly, you can actually format a number as a currency. Using Martin's
example:

decimal d = (decimal)123.9900;
Console.WriteLine(d.ToString("c"));

As I say, I'm reading between the lines, so apologies if this is not
relevant!

HTH,

Rowland.

> Hi,
>
[quoted text clipped - 17 lines]
>>
>> AmountTB.Text = AmountMoney.ToString

Reply to this Message

Simple Convert String to Decimal with 2 places to the right.

Free Magazines