Export (0) Print
Expand All

DataTypeInfos.Item Property

Returns a DataTypeInfo object from the collection.

Namespace:  Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

public DataTypeInfo this[
	Object index
] { get; }

Parameters

index
Type: System.Object
The index of the DataTypeInfo object to retrieve from the collection.

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.

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);
        }
    }
}

Sample Output:

The TypeEnumName of the first item is: DT_R4

The TypeName of the first task is: float

Community Additions

ADD
Show:
© 2015 Microsoft