Condividi tramite

  • Articolo

Metodo TypeCodeFromVarType

Converts a Variant data type to a system TypeCode.

Spazio dei nomi:  Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

Sintassi

'Dichiarazione
Public Shared Function TypeCodeFromVarType ( _
    varType As UShort _
) As TypeCode
'Utilizzo
Dim varType As UShort
Dim returnValue As TypeCode

returnValue = DtsConvert.TypeCodeFromVarType(varType)

public static TypeCode TypeCodeFromVarType(
    ushort varType
)

public:
static TypeCode TypeCodeFromVarType(
    unsigned short varType
)

static member TypeCodeFromVarType : 
        varType:uint16 -> TypeCode 

public static function TypeCodeFromVarType(
    varType : ushort
) : TypeCode

Parametri

Valore restituito

Tipo: System. . :: . .TypeCode
A system TypeCode.

Osservazioni

For a list of the Variant data types, see Tipi di dati di Integration Services.

The following table shows the Variant data types and what TypeCode they are converted to.

Variant Data Type

System TypeCode

VT_EMPTY

System.TypeCode.Empty

VT_NULL

System.TypeCode.DBNull

VT_I2

System.TypeCode.Int16

VT_I4

System.TypeCode.Int32

VT_R4

System.TypeCode.Single

VT_R8

System.TypeCode.Double

VT_CY

System.TypeCode.Decimal

VT_DATE

System.TypeCode.DateTime

VT_BSTR

System.TypeCode.String

VT_DISPATCH

System.TypeCode.Object

VT_ERROR

System.TypeCode.Object

VT_BOOL

System.TypeCode.Boolean

VT_VARIANT

System.TypeCode.Object

VT_UNKNOWN

System.TypeCode.Object

VT_DECIMAL

System.TypeCode.Decimal

VT_I1

System.TypeCode.SByte

VT_UI1

System.TypeCode.Byte

VT_UI2

System.TypeCode.UInt16

VT_UI4

System.TypeCode.UInt32

VT_I8

System.TypeCode.Int64

VT_UI8

System.TypeCode.UInt64

VT_INT

System.TypeCode.Int16

VT_UINT

System.TypeCode.UInt16

VT_VOID

System.TypeCode.Empty