Mapping data types into different environments like .Net and SQL server.
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.BigInt
OleDbType.BigInt
bigint
adBigInt
20
8
Variant
Byte[]
SqlDbType.VarBinary
OleDbType.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.Char
OleDbType.Char
char
adChar
129
X
Char
String
Money
Decimal
SqlDbType.Money
OleDbType.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.DateTime
OleDbType.DBTimeStamp
datetime
smalldatetime
adDBTimeStamp
135
8
4
0
DateTime
Date
Date
Decimal
OleDbType.Decimal
adDecimal
14
Decimal
Variant 6
Double
SqlDbType.Float
OleDbType.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.UniqueIdentifier
OleDbType.Guid
uniqueidentifier
adGUID
72
16
ReplicationID
Variant
Object
OleDbType.IDispatch
adIDispatch
9
Identifier
Number
Int32
SqlDbType.Int
OleDbType.Integer
identity
int
adInteger
3
4
4
AutoNumber
Long Integer
Int
Long
Object
OleDbType.IUnknown
adIUnknown
13
Byte[]
SqlDbType.VarBinary
OleDbType.LongVarBinary
image
adLongVarBinary
205
2147483647
OLEObject
Long Raw
Blob
Variant
String
SqlDbType.VarChar
OleDbType.LongVarChar
text
adLongVarChar
201
2147483647
Memo
Hyperlink
Long
Clob
String
String
SqlDbType.NText
OleDbType.VarWChar
ntext
adLongVarWChar
203
1073741823
Memo
Hyperlink
NClob
String
Decimal
SqlDbType.Decimal
OleDbType.Decimal
decimal
numeric
adNumeric
131
9
Decimal
Decimal
Integer
Number
SmallInt
Variant
Object
OleDbType.PropVariant
adPropVariant
138
Single
SqlDbType.Real
OleDbType.Single
real
adSingle
4
4
Single
Single
Int16,
SqlDbType.SmallInt
OleDbType.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.TinyInt
OleDbType.UnsignedTinyInt
tinyInt
adUnsignedTinyInt
17
1
Byte
Byte
adUserDefined
132
Byte[]
SqlDbType.VarBinary
OleDbType.VarBinary
varbinary
adVarBinary
204
50
ReplicationID
Variant
String
SqlDbType.VarChar
OleDbType.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.NVarChar
OleDbType.VarWChar
nvarchar
adVarWChar
202
X
Text
NVarChar2
String
String
SqlDbType.NChar
OleDbType.WChar
nchar
adWChar
130
X
String
and the Managed Extensions for C++. The table also includes entries for the Object and String classes, for which many languages have corresponding keywords.
Category
Class name
Description
Visual Basic data type
C# data type
Managed Extensions for C++ data type
JScript data type
Integer
Byte
An [...]