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