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]]

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
(e-mail address removed)
http://www.4GuysFromRolla.com

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

 

[Guadala Harry]

Perfect - thanks!

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
(e-mail address removed)
http://www.4GuysFromRolla.com

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