DataTypeInfo.TypeName Property

Article
12/15/2008

Returns the data type name. This field is read-only.

Espace de noms: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

Syntaxe

'Déclaration
Public ReadOnly Property TypeName As String

public string TypeName { get; }

public:
property String^ TypeName {
    String^ get ();
}

/** @property */
public String get_TypeName ()

public function get TypeName () : String

Valeur de propriété

A string that contains a long description of the data type.

Notes

Returns a longer name for the data type. For example, the property returns currency for type of DT_CY.

Exemple

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

Sécurité des threads

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.

Plateformes

Plateformes de développement

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Plateformes cibles