Formatting Strings

[Guadala Harry]

So far into my forray into .NET I have not had to format strings... until
now. I have a stored procedure that returns a decimal value that looks like
this: 12345.1234.

I would like to format it to look like this: $12,345.12

The formatted value should be rounded to two decimal places.

The value to be formatted currently shows up in my code in a DataRow like
this: Convert.ToString(DR_Items["Price"])

Thanks.

[Scott Mitchell [MVP]]

Guadala Harry wrote:

So far into my forray into .NET I have not had to format strings... until
now. I have a stored procedure that returns a decimal value that looks like
this: 12345.1234.

I would like to format it to look like this: $12,345.12

The formatted value should be rounded to two decimal places.

The value to be formatted currently shows up in my code in a DataRow like
this: Convert.ToString(DR_Items["Price"])

Look into String.Format(). There are a number of format specifiers that
you can use that do specific formatting. You'd likely want the currency
formatting here:

string formattedResults = string.Format("{0:c}", DR_Items["Price"]);

hth

--

Scott Mitchell
mi******@4guysfromrolla.com
http://www.4GuysFromRolla.com

* When you think ASP.NET, think 4GuysFromRolla.com!

[Guadala Harry]

Perfect - thanks!
"Scott Mitchell [MVP]" <mi******@4guysfromrolla.com> wrote in message
news:%4*****************@newssvr13.news.prodigy.co m...

Guadala Harry wrote:

So far into my forray into .NET I have not had to format strings... until now. I have a stored procedure that returns a decimal value that looks like this: 12345.1234.

I would like to format it to look like this: $12,345.12

The formatted value should be rounded to two decimal places.

The value to be formatted currently shows up in my code in a DataRow like this: Convert.ToString(DR_Items["Price"])

Look into String.Format(). There are a number of format specifiers that
you can use that do specific formatting. You'd likely want the currency
formatting here:

string formattedResults = string.Format("{0:c}", DR_Items["Price"]);

hth

--

Scott Mitchell
mi******@4guysfromrolla.com
http://www.4GuysFromRolla.com

* When you think ASP.NET, think 4GuysFromRolla.com!