Datatype

ASP.NET ControlDNN KickStart Field type.NET FrameworkSQL ServerADO DataType EnumADO DataType Enum ValueSizeAccessOracleVisual Basic
ASP.NET ControlDNN KickStart Field type.NET
Framework
SQL
Server 
ADO
DataType
Enum
ADO
DataType
Enum
Value
SizeAccessOracleVisual
Basic
6.0
  Int64
SqlDbType.BigIntOleDbType.BigInt
 bigintadBigInt208  Variant
  Byte[]
SqlDbType.VarBinaryOleDbType.Binary
 binary
timestamp
adBinary12850
8
 RawVariant
 Yes/No Boolean
SqlDbType.Bit
OleDbType.Boolean
bit adBoolean11
1
2
  YesNo Boolean
  String
OleDbType.BSTR
 adBSTR8    
  (DataReader) adChapter136    
  Text
Document
String 
SqlDbType.CharOleDbType.Char
 charadChar129X CharString
  MoneyDecimal
SqlDbType.MoneyOleDbType.Currency
money
smallmoney 
adCurrency68
4
0
 Currency Currency
  DateTime
OleDbType.DBDate
 adDate7
0
 DateTime Date
  DateTime
OleDbType.DBDate
 adDBDate133    
  DBFileTime adDBFileTime137    
  DateTime
OleDbType.DBTime
 adDBTime134    
 Date
Time 
DateTime
SqlDbType.DateTimeOleDbType.DBTimeStamp
 datetime
 smalldatetime
adDBTimeStamp1358
4
0
 DateTimeDateDate
  Decimal
OleDbType.Decimal
 adDecimal14  DecimalVariant 6
  Double
SqlDbType.FloatOleDbType.Double
 floatadDouble5 
8
0
 DoubleFloatDouble
  Empty adEmpty0    
  External-Exception
OleDbType.Error
 adError10    
  DateTime
OleDbType.Filetime
 adFileTime64    
  Guid 
SqlDbType.UniqueIdentifierOleDbType.Guid
 uniqueidentifieradGUID7216 ReplicationID Variant
  Object
OleDbType.IDispatch
 adIDispatch9    
  Identifier
Number
Int32
SqlDbType.IntOleDbType.Integer
 identity
int
adInteger34
4
 
 AutoNumber
Long Integer
IntLong
  Object
OleDbType.IUnknown
 adIUnknown13    
  Byte[]
SqlDbType.VarBinaryOleDbType.LongVarBinary
 imageadLongVarBinary2052147483647 OLEObjectLong RawBlobVariant
  String
SqlDbType.VarCharOleDbType.LongVarChar
 textadLongVarChar2012147483647 Memo
Hyperlink
LongClobString
  String
SqlDbType.NTextOleDbType.VarWChar
 ntextadLongVarWChar2031073741823 Memo
Hyperlink
NClobString
  Decimal
SqlDbType.DecimalOleDbType.Decimal
 decimal
numeric
adNumeric1319
 
 DecimalDecimal
Integer
Number
SmallInt
Variant
  Object
OleDbType.PropVariant
 adPropVariant 138    
  Single
SqlDbType.RealOleDbType.Single
 realadSingle 44 Single Single
  Int16,
SqlDbType.SmallIntOleDbType.SmallInt
 smallIntadSmallInt 22 Integer Integer
  Byte
OleDbType.TinyInt
 adTinyInt 16    
  UInt64
OleDbType.UnsignedBigInt
  adUnsignedBigInt21    
  UInt32
OleDbType.UnsignedInt
 adUnsignedInt 19    
  UInt16
OleDbType.UnsignedSmallInt
 adUnsignedSmallInt 18    
  Byte
SqlDbType.TinyIntOleDbType.UnsignedTinyInt
 tinyIntadUnsignedTinyInt 171 
 Byte
 Byte
    adUserDefined 132    
  Byte[] 
SqlDbType.VarBinaryOleDbType.VarBinary
 varbinaryadVarBinary 20450  ReplicationID Variant
  String
SqlDbType.VarCharOleDbType.VarChar
 varcharadVarChar 200X TextVarCharString
  Object
SqlDbType.Variant
OleDbType.Variant
 sql_variantadVariant 128016 VarChar2Variant
  OleDbType.VarNumeric adVarNumeric 139    
  String
SqlDbType.NVarCharOleDbType.VarWChar
 nvarcharadVarWChar 202X TextNVarChar2String
  String
SqlDbType.NCharOleDbType.WChar
 ncharadWChar 130X  String