DataTypeInfos.Item[Object] 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 a DataTypeInfo object from the collection.

public:
 property Microsoft::SqlServer::Dts::Runtime::DataTypeInfo ^ default[System::Object ^] { Microsoft::SqlServer::Dts::Runtime::DataTypeInfo ^ get(System::Object ^ index); };

public Microsoft.SqlServer.Dts.Runtime.DataTypeInfo this[object index] { get; }

member this.Item(obj) : Microsoft.SqlServer.Dts.Runtime.DataTypeInfo

Default Public ReadOnly Property Item(index As Object) As DataTypeInfo

Parameters

index: Object

The index of the DataTypeInfo object to retrieve from the collection.

Property Value

DataTypeInfo

A DataTypeInfo object.

Examples

The following code sample retrieves an item from the collection using two methods. The first method uses the dataInfos[0] syntax to retrieve the entire object located in the first position of the collection and place it in the dtInfo object. After this is done you can retrieve all properties from the dtInfo object as usual. The second method demonstrates how to retrieve a specific property from the first object in the collection.

using System;  
using System.Collections.Generic;  
using System.Text;  
using Microsoft.SqlServer.Dts.Runtime;  

namespace DataTypeInfos_GetEnum_Current  
{  
    class Program  
    {  
        static void Main(string[] args)  
        {  
            //Create the DataTypeInfos collection.  
            DataTypeInfos dataInfos = new Application().DataTypeInfos;  

            //Using the Item method syntax of [x], obtain the first entry.  
            DataTypeInfo dtInfo = dataInfos[0];  
            String nameOfFirstItem = dataInfos[0].TypeName;  

            //Print the name of the task object located at position [0].  
            Console.WriteLine("The TypeEnumName of the first item is: {0}", dtInfo.TypeEnumName);  
            Console.WriteLine("The TypeName of the first task is: {0}", nameOfFirstItem);  
        }  
    }  
}

Imports System  
Imports System.Collections.Generic  
Imports System.Text  
Imports Microsoft.SqlServer.Dts.Runtime  

Namespace DataTypeInfos_GetEnum_Current  
    Class Program  
        Shared  Sub Main(ByVal args() As String)  
            'Create the DataTypeInfos collection.  
            Dim dataInfos As DataTypeInfos =  New Application().DataTypeInfos   

            'Using the Item method syntax of [x], obtain the first entry.  
            Dim dtInfo As DataTypeInfo =  dataInfos(0)   
            Dim nameOfFirstItem As String =  dataInfos(0).TypeName   

            'Print the name of the task object located at position [0].  
            Console.WriteLine("The TypeEnumName of the first item is: {0}", dtInfo.TypeEnumName)  
            Console.WriteLine("The TypeName of the first task is: {0}", nameOfFirstItem)  
        End Sub  
    End Class  
End Namespace

Sample Output:

The TypeEnumName of the first item is: DT_R4

The TypeName of the first task is: float

Remarks

If the call to the Contains method returns true, you can access the specified element in the collection by using the syntax DataTupeInfos[index]. If the Contains method returns false, this property throws an exception. In C#, this property is the indexer for the DataTypeInfos class.

Applies to

Share via