DtsConvert.TypeCodeFromVarType Method

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.

平台

開發平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

目標平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

請參閱

參考

DtsConvert Class
DtsConvert Members
Microsoft.SqlServer.Dts.Runtime Namespace