DataTypeInfo.TypeName Property

Reference

Definition

Namespace:: Microsoft.SqlServer.Dts.Runtime

Assembly:: Microsoft.SqlServer.ManagedDTS.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

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

public string TypeName { get; }

member this.TypeName : string

Public ReadOnly Property TypeName As String

Property Value

String

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

Examples

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

Remarks

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

Applies to

Share via