Monday, December 18, 2017  
You are here:  Knowledge base * MSSQL Server * Data type Register  Login
Data Type Mapping Minimize

 

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

 See also:

Field types for DNN KickStart

  
 

 
Home  |  Company  |  Products  |  Contact  |  Downloads  |  Knowledge base
Copyright (c) 2017 FRENT IT   |  Privacy Statement  |  Terms Of Use