Datatype

ASP.NET Control	DNN KickStart Field type	.NET Framework	SQL Server	ADO DataType Enum	ADO DataType Enum Value	Size	Access	Oracle	Visual Basic

ASP.NET Control	DNN KickStart Field type	.NET Framework	SQL Server	ADO DataType Enum	ADO DataType Enum Value	Size	Access	Oracle	Visual Basic 6.0
		Int64 SqlDbType.BigIntOleDbType.BigInt	bigint	adBigInt	20	8			Variant
		Byte[] SqlDbType.VarBinaryOleDbType.Binary	binary timestamp	adBinary	128	50 8		Raw	Variant
	Yes/No	Boolean SqlDbType.Bit OleDbType.Boolean	bit	adBoolean	11	1 2	YesNo		Boolean
		String OleDbType.BSTR		adBSTR	8
		(DataReader)		adChapter	136
	Text Document	String  SqlDbType.CharOleDbType.Char	char	adChar	129	X		Char	String
	Money	Decimal SqlDbType.MoneyOleDbType.Currency	money smallmoney	adCurrency	6	8 4 0	Currency		Currency
		DateTime OleDbType.DBDate		adDate	7	0	DateTime		Date
		DateTime OleDbType.DBDate		adDBDate	133
		DBFileTime		adDBFileTime	137
		DateTime OleDbType.DBTime		adDBTime	134
	Date Time	DateTime SqlDbType.DateTimeOleDbType.DBTimeStamp	datetime  smalldatetime	adDBTimeStamp	135	8 4 0	DateTime	Date	Date
		Decimal OleDbType.Decimal		adDecimal	14			Decimal	Variant 6
		Double SqlDbType.FloatOleDbType.Double	float	adDouble	5	8 0	Double	Float	Double
		Empty		adEmpty	0
		External-Exception OleDbType.Error		adError	10
		DateTime OleDbType.Filetime		adFileTime	64
		Guid  SqlDbType.UniqueIdentifierOleDbType.Guid	uniqueidentifier	adGUID	72	16	ReplicationID		Variant
		Object OleDbType.IDispatch		adIDispatch	9
	Identifier Number	Int32 SqlDbType.IntOleDbType.Integer	identity int	adInteger	3	4 4	AutoNumber Long Integer	Int	Long
		Object OleDbType.IUnknown		adIUnknown	13
		Byte[] SqlDbType.VarBinaryOleDbType.LongVarBinary	image	adLongVarBinary	205	2147483647	OLEObject	Long RawBlob	Variant
		String SqlDbType.VarCharOleDbType.LongVarChar	text	adLongVarChar	201	2147483647	Memo Hyperlink	LongClob	String
		String SqlDbType.NTextOleDbType.VarWChar	ntext	adLongVarWChar	203	1073741823	Memo Hyperlink	NClob	String
		Decimal SqlDbType.DecimalOleDbType.Decimal	decimal numeric	adNumeric	131	9	Decimal	Decimal Integer Number SmallInt	Variant
		Object OleDbType.PropVariant		adPropVariant	138
		Single SqlDbType.RealOleDbType.Single	real	adSingle	4	4	Single		Single
		Int16, SqlDbType.SmallIntOleDbType.SmallInt	smallInt	adSmallInt	2	2	Integer		Integer
		Byte OleDbType.TinyInt		adTinyInt	16
		UInt64 OleDbType.UnsignedBigInt		adUnsignedBigInt	21
		UInt32 OleDbType.UnsignedInt		adUnsignedInt	19
		UInt16 OleDbType.UnsignedSmallInt		adUnsignedSmallInt	18
		Byte SqlDbType.TinyIntOleDbType.UnsignedTinyInt	tinyInt	adUnsignedTinyInt	17	1	Byte		Byte
				adUserDefined	132
		Byte[]  SqlDbType.VarBinaryOleDbType.VarBinary	varbinary	adVarBinary	204	50	ReplicationID		Variant
		String SqlDbType.VarCharOleDbType.VarChar	varchar	adVarChar	200	X	Text	VarChar	String
		Object SqlDbType.Variant OleDbType.Variant	sql_variant	adVariant	12	8016		VarChar2	Variant
		OleDbType.VarNumeric		adVarNumeric	139
		String SqlDbType.NVarCharOleDbType.VarWChar	nvarchar	adVarWChar	202	X	Text	NVarChar2	String
		String SqlDbType.NCharOleDbType.WChar	nchar	adWChar	130	X			String