Supported Windows SharePoint Services Column Types

Single Line of Text

SPFieldType.Text

single line

None

Multiple lines of text

SPFieldType.Note

line 1

line 2

line 3

None

Choice Drop-Down

SPFieldType.Choice

ChoiceA

ChoiceA from the available choices (ChoiceA, ChoiceB, ChoiceC)

Choice Radio-Buttons

SPFieldType.Choice

#ChoiceB;#ChoiceC;#

ChoiceB and ChoiceC are enabled, ChoiceA is disabled (available choices are ChoiceA, ChoiceB, ChoiceC). Use ;# as a separator.

Number

SPFieldType.Number

123.456

None

Currency USD (or any other)

SPFieldType.Currency

100.00

None

Lookup

SPFieldType.Lookup

1

The number is the item identifier inside the referenced list.

YesNo

SPFieldType.Boolean

1

1=Yes

0=No

Hyperlink or Picture

SPFieldType.URL

http://www.microsoft.com, Microsoft Web Site

URL separated with "," from the display text. The "Microsoft Web Site" text will be a hyperlink to http://www.microsoft.com

Date and Time

SPFieldType.DateTime

2005-02-11T10:05:04

The DateTime as defined by the XML standard for the xs:dateTime. The pattern for dateTime is CCYY-MM-DDThh:mm:ss where CC represents the century, YY the year, MM the month, and DD the day, preceded by an optional leading negative (-) character to indicate a negative number. If the negative character is omitted, positive (+) is assumed. The T is the date/time separator and hh, mm, and ss represent hour, minute, and second, respectively. This representation may be immediately followed by a "Z" to indicate UTC or to indicate the time zone.