Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Converts a Variant data type to a system TypeCode.
Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
Syntax
'Declaration
Public Shared Function TypeCodeFromVarType ( _
varType As UShort _
) As TypeCode
'Usage
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
Parameters
- varType
Type: System.UInt16
The SSIS type code.
Return Value
Type: System.TypeCode
A system TypeCode.
Remarks
For a list of the Variant data types, see Integration Services Data Types.
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 |