Joe Webb

Musing and observations about SQL Server, other technogies, and sometimes just life in general
posts - 85, comments - 857, trackbacks - 0

My Links

News

This blog has moved!

Click here for the new location.

Follow me on Twitter
Add to Technorati Favorites

Search this Blog
 




Archives

Post Categories

About me

Formatting strings

I just completed teaching a Microsoft SQL Server Reporting Services class in Charlotte, North Carolina - a wonderful and beautiful place to visit!

In a couple of the demonstrations, we used some predefined formatting strings to customize the way a user can see a value in a report. For example, we used C0 to display a currency value with no numbers to the right of a decimal point.

One question that almost always comes up during the class is: where can I find a list of those predefined formatting strings?

Microsoft has them on the MSDN Library site, but the are buried and rather difficult to find. So, I thought I'd share them with you here. These links are for v2.0 of the .NET Framework, however these pages include links to other versions including v1.1, v3.0, and v3.5 of the .NET Framework.


Enjoy!

Joe
kick it on DotNetKicks.com

Print | posted on Wednesday, March 12, 2008 5:46 PM | Filed Under [ C# Other Technologies SQL Server ]

Feedback

Gravatar

# re: Formatting strings

I made those into cheat sheets: http://john-sheehan.com/blog/index.php/net-cheat-sheets/
3/13/2008 1:16 AM | John S.
Gravatar

# re: Formatting strings

Good stuff, Joe, this will help those who somehow feel that it is just "easier" to format via converting everything to VARCHAR within the database!
3/15/2008 1:37 PM | Jeff
Gravatar

# re: Formatting strings

Thanks, I've been looking for these!
1/14/2009 10:05 AM | Dan
Gravatar

# re: Formatting strings

So, I thought I'd share them with you here. These links are for v2.0 of the .NET Framework, however these pages include links to other versions including v1.1, v3.0, and v3.5 of the .NET Framework.

furry boots | columbia outlet | discount makeup | north face jackets
10/20/2010 2:31 AM | snow boots for women
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET