Format DataItem as Currency and NO decimals

[D. Shane Fowlkes]

Quick question -

I have output from a Money MS SQL field going into a repeater's dataitem.
The db does not store any cents (decimals). How can I get this on the page:

<%#DataBinder.Eval(Container.DataItem, "Revenue", "{0:C}")%>

...NOT to display any decimals or cents?

[Nathan Sokalski]

Rather than try to convert the value to Currency, simply prepend it with a $
like the following:

<%#DataBinder.Eval(Container.DataItem, "Revenue", "${0}")%>

If you would like, you can specify that an integer format be used (such as
"${0:D}"). For more information, see

ms-help://MS.VSCC.2003/MS.MSDNQTR.2003FEB.1033/cpguide/html/cpconstandardnumericformatstrings.htm

Good Luck!
--
Nathan Sokalski
nj********@hotmail.com
http://www.nathansokalski.com/

"D. Shane Fowlkes" <sh**********@h-o-t-m-a-i-l.com> wrote in message
news:e4**************@TK2MSFTNGP14.phx.gbl...

Quick question -

I have output from a Money MS SQL field going into a repeater's dataitem.
The db does not store any cents (decimals). How can I get this on the
page:

<%#DataBinder.Eval(Container.DataItem, "Revenue", "{0:C}")%>

..NOT to display any decimals or cents?