Método DtsConvert.TypeCodeFromVarType
Converts a Variant data type to a system TypeCode.
Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (em Microsoft.SqlServer.ManagedDTS.dll)
Sintaxe
'Declaração
Public Shared Function TypeCodeFromVarType ( _
varType As UShort _
) As TypeCode
'Uso
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
Parâmetros
- varType
Tipo: System.UInt16
The SSIS type code.
Valor de retorno
Tipo: System.TypeCode
A system TypeCode.
Comentários
For a list of the Variant data types, see Tipos de dados do 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 |