Propriedade do RDL DataTypeInfo.TypeName
Returns the data type name. This field is read-only.
Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (em Microsoft.SqlServer.ManagedDTS.dll)
Sintaxe
'Declaração
Public ReadOnly Property TypeName As String
Get
'Uso
Dim instance As DataTypeInfo
Dim value As String
value = instance.TypeName
public string TypeName { get; }
public:
property String^ TypeName {
String^ get ();
}
member TypeName : string
function get TypeName () : String
Valor da propriedade
Tipo: System.String
A string that contains a long description of the data type.
Comentários
Returns a longer name for the data type. For example, the property returns currency for type of DT_CY.
Exemplos
The following code example iterates through the collection and prints the TypeEnumName and TypeName of each data type in SQL Server Integration Services (SSIS).
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
namespace DataTypeInfo_Properties
{
class Program
{
static void Main(string[] args)
{
//Create the DataTypeInfos collection.
DataTypeInfos dataInfos = new Application().DataTypeInfos;
//Iterate over the collection, printing the values
//of the properties.
foreach (DataTypeInfo dInfo in dataInfos)
{
Console.WriteLine("TypeName: {0}, TypeEnumName: {1}", dInfo.TypeName, dInfo.TypeEnumName);
//Console.WriteLine("TypeEnumName {0}", dInfo.TypeEnumName);
}
}
}
}
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Namespace DataTypeInfo_Properties
Class Program
Shared Sub Main(ByVal args() As String)
'Create the DataTypeInfos collection.
Dim dataInfos As DataTypeInfos = New Application().DataTypeInfos
'Iterate over the collection, printing the values
'of the properties.
Dim dInfo As DataTypeInfo
For Each dInfo In dataInfos
Console.WriteLine("TypeName: {0}, TypeEnumName: {1}", dInfo.TypeName, dInfo.TypeEnumName)
'Console.WriteLine("TypeEnumName {0}", dInfo.TypeEnumName);
Next
End Sub
End Class
End Namespace
Sample Output:
TypeName: float, TypeEnumName: DT_R4
TypeName: double-precision float, TypeEnumName: DT_R8
TypeName: currency, TypeEnumName: DT_CY
TypeName: date, TypeEnumName: DT_DATE
TypeName: Boolean, TypeEnumName: DT_BOOL
TypeName: decimal, TypeEnumName: DT_DECIMAL
TypeName: single-byte signed integer, TypeEnumName: DT_I1
TypeName: single-byte unsigned integer, TypeEnumName: DT_UI1
TypeName: two-byte signed integer, TypeEnumName: DT_I2
TypeName: two-byte unsigned integer, TypeEnumName: DT_UI2
TypeName: four-byte signed integer, TypeEnumName: DT_I4
TypeName: four-byte unsigned integer, TypeEnumName: DT_UI4
TypeName: eight-byte signed integer, TypeEnumName: DT_I8
TypeName: eight-byte unsigned integer, TypeEnumName: DT_UI8
TypeName: file timestamp, TypeEnumName: DT_FILETIME
TypeName: unique identifier, TypeEnumName: DT_GUID
TypeName: byte stream, TypeEnumName: DT_BYTES
TypeName: string, TypeEnumName: DT_STR
TypeName: Unicode string, TypeEnumName: DT_WSTR
TypeName: numeric, TypeEnumName: DT_NUMERIC
TypeName: database date, TypeEnumName: DT_DBDATE
TypeName: database time, TypeEnumName: DT_DBTIME
TypeName: database timestamp, TypeEnumName: DT_DBTIMESTAMP
TypeName: image, TypeEnumName: DT_IMAGE
TypeName: text stream, TypeEnumName: DT_TEXT
TypeName: Unicode text stream, TypeEnumName: DT_NTEXT