string number format

[LW Irving]

when I use the snippet below

price = "$" + reader["start_pric e"].ToString() + " to $" +
reader["end_price"].ToString();

the price is returned with 4 decimal places

I thought I could do; reader["start_pric e"].ToString("C") to format the
string as currency and do away "$" + from the line

or reader["start_pric e"].ToString("00.0 0") to at least specify the decimal
places

but niether work

What am I doing wrong

Regards

Wayne

[LW Irving]

I also tried
price = "$" + Convert.ToDecim al( reader["start_pric e"]).ToString("0.0 0") + "
to $" + Convert.ToDecim al( reader["end_price"]).ToString("C") ;

I tried tostring("C2") as well

which compiled at least but did not make any difference to the output ie
still four decimal places

"LW Irving" <li*****@coffs. com.au> wrote in message
news:ue******** ******@TK2MSFTN GP12.phx.gbl...

when I use the snippet below

price = "$" + reader["start_pric e"].ToString() + " to $" +
reader["end_price"].ToString();

the price is returned with 4 decimal places

I thought I could do; reader["start_pric e"].ToString("C") to format the
string as currency and do away "$" + from the line

or reader["start_pric e"].ToString("00.0 0") to at least specify the decimal
places

but niether work

What am I doing wrong

Regards

Wayne

[José Joye]

When you try
price = Convert.ToDecim al( reader["end_price"]).ToString("C") ;

what do you get as price?

José

"LW Irving" <li*****@coffs. com.au> a écrit dans le message de
news:u5******** ******@TK2MSFTN GP10.phx.gbl...

I also tried
price = "$" + Convert.ToDecim al( reader["start_pric e"]).ToString("0.0 0") + " to $" + Convert.ToDecim al( reader["end_price"]).ToString("C") ;

I tried tostring("C2") as well

which compiled at least but did not make any difference to the output ie
still four decimal places

"LW Irving" <li*****@coffs. com.au> wrote in message
news:ue******** ******@TK2MSFTN GP12.phx.gbl...

when I use the snippet below

price = "$" + reader["start_pric e"].ToString() + " to $" +
reader["end_price"].ToString();

the price is returned with 4 decimal places

I thought I could do; reader["start_pric e"].ToString("C") to format the string as currency and do away "$" + from the line

or reader["start_pric e"].ToString("00.0 0") to at least specify the decimal places

but niether work

What am I doing wrong

Regards

Wayne

[djozy]

Please,can you tell me,witch function converts integer to
string?
Thank you

[Jon Skeet [C# MVP]]

LW Irving <li*****@coffs. com.au> wrote:

when I use the snippet below

price = "$" + reader["start_pric e"].ToString() + " to $" +
reader["end_price"].ToString();

the price is returned with 4 decimal places

I thought I could do; reader["start_pric e"].ToString("C") to format the
string as currency and do away "$" + from the line

or reader["start_pric e"].ToString("00.0 0") to at least specify the decimal
places

but niether work

What am I doing wrong

Firstly, we need to know what reader["start_pric e"] is returning. Then
we need to know what you mean by "but neither work" - in what *way*
don't they work?

--
Jon Skeet - <sk***@pobox.co m>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too

[Jon Skeet [C# MVP]]

djozy <an*******@disc ussions.microso ft.com> wrote:

Please,can you tell me,witch function converts integer to
string?

Convert.ToStrin g, or Int32.ToString, or String.Format would all be good
starting points.

--
Jon Skeet - <sk***@pobox.co m>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too

[Mitchell Geere]

As far as I know (Convert.ToDeci mal(Value)).ToS tring("0.00") should work
because it come from the IFormatter interface and is the same one used for
Float's. Double's etc...

I have used this many times... oh and there is just one thing you shoudl
undestand about the IFormatter if you do the following
(Convert.ToDeci mal(Value)).ToS tring("0.00") it will round up to the nearest
2 it doesnt just chop off the rest... which is cool

Mitch

"LW Irving" <li*****@coffs. com.au> wrote in message
news:ue******** ******@TK2MSFTN GP12.phx.gbl...

when I use the snippet below

price = "$" + reader["start_pric e"].ToString() + " to $" +
reader["end_price"].ToString();

the price is returned with 4 decimal places

I thought I could do; reader["start_pric e"].ToString("C") to format the
string as currency and do away "$" + from the line

or reader["start_pric e"].ToString("00.0 0") to at least specify the decimal
places

but niether work

What am I doing wrong

Regards

Wayne

[LW Irving]

Thanks for the replies
I was mistaken (ie. I was altering a method that was not being called
therefore there was no observable change)
The start_price variable is a sql variable in the data base it is decared as
smallmoney, it seems to behave as if double.

These two statements work
price = "$" + Convert.ToDecim al(reader["start_pric e"]).ToString("0.0 0")
or
price = Convert.ToDecim al(reader["start_pric e"]).ToString("C",
NumberFormatInf o.CurrentInfo)
With the second I do not need to put in the dollar sign

I need to do this about 120 - 130 times to fix the code ( I did not write it
originally and am just learning c# as I go)

these methods are on pages a in a folder called modules on pages called
along the lines of S3generalDB.cs

So my next question is can I do something like

price = myprice

and have a method that says

myprice = Convert.ToDecim al(reader["start_pric e"]).ToString("C",
NumberFormatInf o.CurrentInfo)

if should I put it at the top of the page , and how should I declare it

Sorry if this is too simple but I am really new to .net and C#

Regards

Wayne



"LW Irving" <li*****@coffs. com.au> wrote in message
news:ue******** ******@TK2MSFTN GP12.phx.gbl...

when I use the snippet below

price = "$" + reader["start_pric e"].ToString() + " to $" +
reader["end_price"].ToString();

the price is returned with 4 decimal places

I thought I could do; reader["start_pric e"].ToString("C") to format the
string as currency and do away "$" + from the line

or reader["start_pric e"].ToString("00.0 0") to at least specify the decimal
places

but niether work

What am I doing wrong

Regards

Wayne

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.543 / Virus Database: 337 - Release Date: 11/21/2003

[Mitchell Geere]

Well because C# is Component/Object Orientated (Where as C is Procedural
i.e. declare first then use etc...)
Yes Something like this:
decimal myprice = 0.0M;
decimal price = myprice;

myprice = Convert.ToDecim al(reader["start_pric e"]).ToString("C",
NumberFormatInf o.CurrentInfo);

: will work becuase C# doesnt look at the lines and say erf oops here is
something wrong, to get a better grasp of how C#/.NET works I recommend
familiarise yourself with MSIL the underlying stuff that makes .NET,.NET...
for instance if you look at the code above in MSIL (compile the view exe or
dll in ILDASM) you will notice that you are doing quite a bit of boxing and
unboxing. (Casting from Reference Type to Value Type and Vice Versa) Try
this.... SQL types are said to be more accurate...

decimal myprice = 0.0M;

string price = myprice.ToStrin g("C", NumberFormatInf o.CurrentInfo)
// If you call price here now you will get $0.00
myprice = (decimal)myRead er.GetSqlMoney( 0);
// but if you call it here (lets say the DB returns 10.0000) you will get
$10.00 does this clear things up ??

Mitch

"LW Irving" <li*****@coffs. com.au> wrote in message
news:u5******** *****@TK2MSFTNG P11.phx.gbl...

Thanks for the replies
I was mistaken (ie. I was altering a method that was not being called
therefore there was no observable change)
The start_price variable is a sql variable in the data base it is decared as smallmoney, it seems to behave as if double.

These two statements work
price = "$" + Convert.ToDecim al(reader["start_pric e"]).ToString("0.0 0")
or
price = Convert.ToDecim al(reader["start_pric e"]).ToString("C",
NumberFormatInf o.CurrentInfo)
With the second I do not need to put in the dollar sign

I need to do this about 120 - 130 times to fix the code ( I did not write it originally and am just learning c# as I go)

these methods are on pages a in a folder called modules on pages called
along the lines of S3generalDB.cs

So my next question is can I do something like

price = myprice

and have a method that says

myprice = Convert.ToDecim al(reader["start_pric e"]).ToString("C",
NumberFormatInf o.CurrentInfo)

if should I put it at the top of the page , and how should I declare it

Sorry if this is too simple but I am really new to .net and C#

Regards

Wayne



"LW Irving" <li*****@coffs. com.au> wrote in message
news:ue******** ******@TK2MSFTN GP12.phx.gbl...

when I use the snippet below

price = "$" + reader["start_pric e"].ToString() + " to $" +
reader["end_price"].ToString();

the price is returned with 4 decimal places

I thought I could do; reader["start_pric e"].ToString("C") to format the string as currency and do away "$" + from the line

or reader["start_pric e"].ToString("00.0 0") to at least specify the decimal places

but niether work

What am I doing wrong

Regards

Wayne

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.543 / Virus Database: 337 - Release Date: 11/21/2003