Méthode Application.DataTypeInfoFromDataType

Article
04/27/2013

Returns the DataTypeInfo object for the specified data type.

Cette API n'est pas conforme CLS.

Espace de noms : Microsoft.SqlServer.Dts.Runtime
Assembly : Microsoft.SqlServer.ManagedDTS (en Microsoft.SqlServer.ManagedDTS.dll)

Syntaxe

'Déclaration
<CLSCompliantAttribute(False)> _
Public Function DataTypeInfoFromDataType ( _
    dt As DataType _
) As DataTypeInfo
'Utilisation
Dim instance As Application 
Dim dt As DataType 
Dim returnValue As DataTypeInfo 

returnValue = instance.DataTypeInfoFromDataType(dt)

[CLSCompliantAttribute(false)]
public DataTypeInfo DataTypeInfoFromDataType(
    DataType dt
)

[CLSCompliantAttribute(false)]
public:
DataTypeInfo^ DataTypeInfoFromDataType(
    DataType dt
)

[<CLSCompliantAttribute(false)>]
member DataTypeInfoFromDataType : 
        dt:DataType -> DataTypeInfo

public function DataTypeInfoFromDataType(
    dt : DataType
) : DataTypeInfo

Paramètres

dt
Type : Microsoft.SqlServer.Dts.Runtime.Wrapper.DataType
The data type.

Valeur de retour

Type : Microsoft.SqlServer.Dts.Runtime.DataTypeInfo
A DataTypeInfo object.

Notes

This method lets you get data type information for a specific data type. For example, if you pass "DT_I4" in the dt parameter, the return value is the DataTypeInfo object that contains the enumeration name of "DT_I4" and the type name of "four-byte signed integer". This information is useful for displaying the type information in a user interface or error message. For more information about data types, see Types de données d'Integration Services.

Remarques à l'attention des appelants

This method requires the addition of the Microsoft.SqlServer.Dts.Runtime.Wrapper to the project. In the C# code example, the using directive has aliased this namespace with the variable, Wrapper.

Exemples

The following code example retrieves the name of the type, DT_I4.

#region Using directives
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
using Wrapper = Microsoft.SqlServer.Dts.Runtime.Wrapper;
#endregion

namespace Application_and_Package
{
    class PackageTest
    {
        static void Main(string[] args)
        {
            Application app = new Application();
            DataTypeInfo dti = app.DataTypeInfoFromDataType(Wrapper.DataType.DT_I4);
           Console.WriteLine("DataType = " + dti.TypeName);
        }
    }
}

#Region "Using directives
Imports System
Imports System".Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Imports Wrapper = Microsoft.SqlServer.Dts.Runtime.Wrapper
#End Region
 
Namespace Application_and_Package
    Class PackageTest
        Sub Main(ByVal args() As String)
            Dim app As Application =  New Application() 
            Dim dti As DataTypeInfo =  app.DataTypeInfoFromDataType(Wrapper.DataType.DT_I4) 
           Console.WriteLine("DataType = " + dti.TypeName)
        End Sub
    End Class
End Namespace

Sample Output:

DataType = four-byte signed integer

Voir aussi

Référence

Application Classe

Espace de noms Microsoft.SqlServer.Dts.Runtime

Partager via