Pieter, Author at PieterBrinkman.com

10 July 2008

String.Format with C#

In this post I will add examples of String.Format or links to sites with good examples.

Double

[code:c#]


//&nbsp;just two decimal places 
String.Format("{0:0.00}", 123.4567);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // "123.46" 
String.Format("{0:0.00}", 123.4);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // "123.40" 
String.Format("{0:0.00}", 123.0);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // "123.00"


// max. two decimal places 
String.Format("{0:0.##}", 123.4567);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // "123.46" 
String.Format("{0:0.##}", 123.4);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // "123.4" 
String.Format("{0:0.##}", 123.0);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // "123"


// at least two digits before decimal point 
String.Format("{0:00.0}", 123.4567);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // "123.5" 
String.Format("{0:00.0}", 23.4567);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // "23.5" 
String.Format("{0:00.0}", 3.4567);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // "03.5" 
String.Format("{0:00.0}", -3.4567);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // "-03.5"


String.Format("{0:0,0.0}", 12345.67);&nbsp;&nbsp;&nbsp;&nbsp; // "12,345.7" 
String.Format("{0:0,0}", 12345.67);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // "12,346"


String.Format("{0:0.0}", 0.0);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // "0.0" 
String.Format("{0:0.#}", 0.0);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // "0" 
String.Format("{0:#.0}", 0.0);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // ".0" 
String.Format("{0:#.#}", 0.0);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // ""


String.Format("{0,10:0.0}", 123.4567);&nbsp;&nbsp;&nbsp; // "&nbsp;&nbsp;&nbsp;&nbsp; 123.5" 
String.Format("{0,-10:0.0}", 123.4567);&nbsp;&nbsp; // "123.5&nbsp;&nbsp;&nbsp;&nbsp; " 
String.Format("{0,10:0.0}", -123.4567);&nbsp;&nbsp; // "&nbsp;&nbsp;&nbsp; -123.5" 
String.Format("{0,-10:0.0}", -123.4567);&nbsp; // "-123.5&nbsp;&nbsp;&nbsp; "


String.Format("{0:0.00;minus 0.00;zero}", 123.4567);&nbsp;&nbsp; // "123.46" 
String.Format("{0:0.00;minus 0.00;zero}", -123.4567);&nbsp; // "minus 123.46" 
String.Format("{0:0.00;minus 0.00;zero}", 0.0);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // "zero"


[/code]

Source: http://www.csharp-examples.net/string-format-double/

Integer

[code:c#]

String.Format("{0:00000}", 15); // "00015"
String.Format("{0:00000}", -15); // "-00015"

String.Format("{0,5}", 15);              // "   15"
String.Format("{0,-5}", 15);             // "15   "
String.Format("{0,5:000}", 15);          // " 015"
String.Format("{0,-5:000}", 15);         // "015 "

String.Format("{0:#;minus #}", 15); // "15"
String.Format("{0:#;minus #}", -15); // "minus 15"
String.Format("{0:#;minus #;zero}", 0); // "zero"

String.Format("{0:+### ### ### ###}", 447900123456); // "+447 900 123 456"
String.Format("{0:##-####-####}", 8958712551); // "89-5871-2551"

[/code]

Source: http://www.csharp-examples.net/string-format-int/

DateTime

[code:c#]

// create date time 2008-03-09 16:05:07.123
DateTime dt = new DateTime(2008, 3, 9, 16, 5, 7, 123);

String.Format("{0:y yy yyy yyyy}", dt); // "8 08 008 2008"   year
String.Format("{0:M MM MMM MMMM}", dt); // "3 03 Mar March" month
String.Format("{0:d dd ddd dddd}", dt); // "9 09 Sun Sunday" day
String.Format("{0:h hh H HH}",     dt); // "4 04 16 16"      hour 12/24
String.Format("{0:m mm}",          dt); // "5 05"            minute
String.Format("{0:s ss}",          dt); // "7 07"            second
String.Format("{0:f ff fff ffff}", dt); // "1 12 123 1230"   sec.fraction
String.Format("{0:F FF FFF FFFF}", dt); // "1 12 123 123"    without zeroes
String.Format("{0:t tt}",          dt); // "P PM"            A.M. or P.M.
String.Format("{0:z zz zzz}",      dt); // "-6 -06 -06:00"   time zone

// date separator in german culture is "." (so "/" changes to ".")
String.Format("{0:d/M/yyyy HH:mm:ss}", dt); // "9/3/2008 16:05:07" – english (en-US)
String.Format("{0:d/M/yyyy HH:mm:ss}", dt); // "9.3.2008 16:05:07" – german (de-DE)

// month/day numbers without/with leading zeroes
String.Format("{0:M/d/yyyy}", dt); // "3/9/2008"
String.Format("{0:MM/dd/yyyy}", dt); // "03/09/2008"

// day/month names
String.Format("{0:ddd, MMM d, yyyy}", dt); // "Sun, Mar 9, 2008"
String.Format("{0:dddd, MMMM d, yyyy}", dt); // "Sunday, March 9, 2008"

// two/four digit year
String.Format("{0:MM/dd/yy}", dt); // "03/09/08"
String.Format("{0:MM/dd/yyyy}", dt); // "03/09/2008"

String.Format("{0:t}", dt); // "4:05 PM"                         ShortTime
String.Format("{0:d}", dt); // "3/9/2008"                        ShortDate
String.Format("{0:T}", dt); // "4:05:07 PM"                      LongTime
String.Format("{0:D}", dt); // "Sunday, March 09, 2008"          LongDate
String.Format("{0:f}", dt); // "Sunday, March 09, 2008 4:05 PM" LongDate+ShortTime
String.Format("{0:F}", dt); // "Sunday, March 09, 2008 4:05:07 PM" FullDateTime
String.Format("{0:g}", dt); // "3/9/2008 4:05 PM"                ShortDate+ShortTime
String.Format("{0:G}", dt); // "3/9/2008 4:05:07 PM"             ShortDate+LongTime
String.Format("{0:m}", dt); // "March 09"                        MonthDay
String.Format("{0:y}", dt); // "March, 2008"                     YearMonth
String.Format("{0:r}", dt); // "Sun, 09 Mar 2008 16:05:07 GMT"   RFC1123
String.Format("{0:s}", dt); // "2008-03-09T16:05:07"             SortableDateTime
String.Format("{0:u}", dt); // "2008-03-09 16:05:07Z"            UniversalSortableDateTime

[/code]

Source: http://www.csharp-examples.net/string-format-datetime/

4 July 2008

convert UnixTime to DateTime

In an RSS feed I only had an UnixTime. For presentation I needed to convert this string to datetime. I did this with this code

[code:c#]

DateTime itemDateTime = new DateTime(1970, 1, 1, 0, 0, 0).AddSeconds(item.unixTime);

[/code]

No idea what it does but it works 😀

26 June 2008

MsSql: How to enable clr (to run c# / vb code in SQL)

Execute the next query to enable CLR.

[code:c#]

// Turn advanced options on

EXEC sp_configure 'show advanced options' , '1';

reconfigure;

EXEC sp_configure 'clr enabled' , '1'

reconfigure;

// Turn advanced options back off

EXEC sp_configure 'show advanced options' , '0';

[/code]

More info about CLR on Microsoft MSDN.

26 June 2008

Regular Expressions and Matchhandlers

For a project I need te get the email adresses out of a string with all kinds of text in it. After a lot of trying I found the matchhandler method. It is quite easy, you just need to adjust the Replace command and add a MatchEvaluator. Then you can use the matchhandler to do anything with the right string. In this case I´m adding it to a generic list.

[code:c#]

Regex.Replace(source, @"([a-zA-Z_0-9.-]+@[a-zA-Z_0-9.-]+.w+)", new MatchEvaluator(MatchHandler));

[/code]

And add the string to the generic list.

[code:c#]

private string MatchHandler(Match m)

{

col.Add(m.Value);

return m.Value;

}

[/code]

25 June 2008

Asp.Net AJAX controltoolkit javascript funtions

I've search them all up for a 1000 times. Now I'm going to write them down as reference. This post will grow in the next few months.

Remember do not forget to set the behaviorId of the control.

References:

CollapsiblePanelExtender
Expand:

$find('BehaviorId')._doOpen();

Collapse:

$find('BehaviorId')._doClose();
$find('BehaviorId').collapsePanel();

ModalPopupExtender
Show popup:

$find('BehaviorId').show();

Hide popup:

$find('BehaviorId').hide();

23 June 2008

String Extension Method: IsGuid()

I wrote an extension method for the string type. With this method you can check if an string is an Guid. The method returns a Bool.

[code:c#]

public static class StringExtensions
{
public static bool IsGuid(this string input)
{
    Regex isGuid = new Regex(@"^({){0,1}[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}(}){0,1}$", RegexOptions.Compiled);
    bool isValid = false;
    if (input != null)
    {
      if (isGuid.IsMatch(input))
      {
        isValid = true;
      }
    }
return isValid;
}
}

[/code]

If you're wondering I didn't wrote the Regex myself 🙂 (but it works)

This brute-force method is mutch faster (thanks to Arjan and Tag for the comments):

[code:c#]

public static bool IsGuid(this string input)
{
try
{
new Guid(input);
return true;
}
catch (ArgumentNullException) {}
catch (FormatException) {}
catch (OverflowException) {}
return false;
}

[/code]

A good example how extension methods can make some things easier.

Hope it helps!

11 June 2008

Using Session with a Web Handler File (ashx)

In on of our project we use ASHX file to dynamicly generate stylesheets depending on the user. An problem occurred when the userdata was loaded from the Session. The Session object was NULL.

After searching the internet I found the solution for this problem. You need to implement the folowing interfaces on the ASHX; IRequiresSessionState and IReadOnlySessionState. See example below.

[code:c#]

public class Style : IHttpHandler, IRequiresSessionState, IReadOnlySessionState {}

[/code]