Data Types Supported by External List InfoPath Forms

Applies to: SharePoint Server 2010

The following table lists the data types that are supported by external list InfoPath forms.

Table 1. External list InfoPath forms supported data types

.NET Type	XSD Type	Inferred InfoPath Control Type
System.String	string	Text box
System.SByte	byte	Text box
System.Int16	short	Text box
System.Int32	int	Text box
System.Int64	long	Text box
System.Byte	unsignedByte	Text box
System.UInt16	unsignedShort	Text box
System.UInt32	unsignedInt	Text box
System.UInt64	unsignedLong	Text box
System.Decimal	decimal	Text box
System.Boolean	boolean	Check box
System.Double	double	Text box
System.Single	float	Text box
System.DateTime	dateTime	Date picker and text box
System.TimeSpan	duration	Text box
System.Guid	string (with pattern restriction)	Text box
Enum	string (with enumeration restriction)	Drop down list box
[Flags] Enum	Enumeration of boolean’s	Collection of check boxes
System.Byte[]	base64Binary	File attachment
<Not Mapped>	normalizedString	Text box
<Not Mapped>	token	Text box
<Not Mapped>	anyURI	Hyperlink
<Not Mapped>	date	Date picker
<Not Mapped>	time	Text box
<Not Mapped>	integer	Text box
<Not Mapped>	negativeInteger	Text box
<Not Mapped>	nonNegativeInteger	Text box
<Not Mapped>	nonPositiveInteger	Text box
<Not Mapped>	positiveInteger	Text box
External Item Picker	External Item Picker	External Item Picker

Additional resources