Propriedade do RDL DataTypeInfos.Item
Returns a DataTypeInfo object from the collection.
Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (em Microsoft.SqlServer.ManagedDTS.dll)
Sintaxe
'Declaração
Public ReadOnly Default Property Item ( _
index As Object _
) As DataTypeInfo
Get
'Uso
Dim instance As DataTypeInfos
Dim index As Object
Dim value As DataTypeInfo
value = instance(index)
public DataTypeInfo this[
Object index
] { get; }
public:
property DataTypeInfo^ default[Object^ index] {
DataTypeInfo^ get (Object^ index);
}
member Item : DataTypeInfo
JScript dá suporte ao uso de propriedades indexadas, mas não à declaração de propriedades novas.
Parâmetros
- index
Tipo: System.Object
The index of the DataTypeInfo object to retrieve from the collection.
Valor da propriedade
Tipo: Microsoft.SqlServer.Dts.Runtime.DataTypeInfo
A DataTypeInfo object.
Comentários
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.
Exemplos
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