DtsConvert.TypeCodeFromVarType Method

Статья
12/15/2008

Converts a Variant data type to a system TypeCode. This method is not CLS-compliant.

Пространство имен: Microsoft.SqlServer.Dts.Runtime
Сборка: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

Синтаксис

'Декларация
Public Shared Function TypeCodeFromVarType ( _
    varType As UShort _
) As TypeCode

public static TypeCode TypeCodeFromVarType (
    ushort varType
)

public:
static TypeCode TypeCodeFromVarType (
    unsigned short varType
)

public static TypeCode TypeCodeFromVarType (
    UInt16 varType
)

public static function TypeCodeFromVarType (
    varType : ushort
) : TypeCode

Параметры

varType
The SSIS type code.

Возвращаемое значение

A system TypeCode.

Замечания

For a list of the Variant data types, see Типы данных служб 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

Синхронизация потоков

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Платформы

Платформы разработки

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

Целевые платформы