Aracılığıyla paylaş

  • Makale

Connections.Item Özelliği

Döndürür bir ConnectionManager gelen nesne Connections koleksiyon.

Ad Alanı:  Microsoft.SqlServer.Dts.Runtime
Derleme:  Microsoft.SqlServer.ManagedDTS (Microsoft.SqlServer.ManagedDTS içinde.dll)

Sözdizimi

'Bildirim
Public ReadOnly Default Property Item ( _
    index As Object _
) As ConnectionManager
    Get
'Kullanım
Dim instance As Connections
Dim index As Object
Dim value As ConnectionManager

value = instance(index)

public ConnectionManager this[
    Object index
] { get; }

public:
property ConnectionManager^ default[Object^ index] {
    ConnectionManager^ get (Object^ index);
}

member Item : ConnectionManager

JScript, dizinli özelliklerin kullanılmasını destekler, ancak yenilerinin bildirilmesini desteklemez.

Parametreler

Açıklamalar

Yoksa çağrısı Contains yöntem döndürür doğru, belirtilen öğe erişebilirsiniz koleksiyon sözdizimini kullanarak Connections[index].Contains yöntem döndürür yanlış, bu özellik bir istisna atar.C# ile dizinleyici için bu özellik olan Connections WalkTree

Örnekler

Aşağıdaki kod örneği, öğe alır koleksiyon iki yöntemi kullanarak.İlk yöntem kullanır conns[0] tüm nesneyi almak için sözdizimi ilk konumda bulunan koleksiyon ve bunu koymak myConnMgr değişkeni.Şimdi tüm özelliklerini al myConnMgr her zamanki gibi.İkinci yöntem ilk nesne, belirli bir özellik alır koleksiyon kullanarak conns[0].<property> sözdizimi.

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

namespace Connections_Item
{
    class Program
    {
        static void Main(string[] args)
        {
            // The package is one of the SSIS Samples.
            string mySample = @"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx";

            // Create an application and load the sample.
            Application app = new Application();
            Package pkg = app.LoadPackage(mySample, null);
            Connections conns = pkg.Connections;

            //Using the Item method syntax of [x], obtain the
            // entire first entry, and then just the name.
            ConnectionManager myConnMgr = conns[0];
            String nameOfFirstItem = conns[0].Name;

            //Print the name of the connection manager located at position [0].
            Console.WriteLine("The ID of the first connection info is: {0}", myConnMgr.ID);
            Console.WriteLine("The Name of the first connection info is: {0}", nameOfFirstItem);
        }
    }
}

Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
 
Namespace Connections_Item
    Class Program
        Shared  Sub Main(ByVal args() As String)
            ' The package is one of the SSIS Samples.
            Dim mySample As String =  "C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx" 
 
            ' Create an application and load the sample.
            Dim app As Application =  New Application() 
            Dim pkg As Package =  app.LoadPackage(mySample,Nothing) 
            Dim conns As Connections =  pkg.Connections 
 
            'Using the Item method syntax of [x], obtain the
            ' entire first entry, and then just the name.
            Dim myConnMgr As ConnectionManager =  conns(0) 
            Dim nameOfFirstItem As String =  conns(0).Name 
 
            'Print the name of the connection manager located at position [0].
            Console.WriteLine("The ID of the first connection info is: {0}", myConnMgr.ID)
            Console.WriteLine("The Name of the first connection info is: {0}", nameOfFirstItem)
        End Sub
    End Class
End Namespace

Örnek Çıktı:

The ID of the first connection info is: {B52C0D78-5402-4544-BFEC-2BE203900C91}

The Name of the first connection info is: Create_Execute_Process_Dest.sql