Condividi tramite


Executables.Item[Object] Proprietà

Definizione

Ottiene un oggetto Executable dalla raccolta.

public:
 property Microsoft::SqlServer::Dts::Runtime::Executable ^ default[System::Object ^] { Microsoft::SqlServer::Dts::Runtime::Executable ^ get(System::Object ^ index); };
public Microsoft.SqlServer.Dts.Runtime.Executable this[object index] { get; }
member this.Item(obj) : Microsoft.SqlServer.Dts.Runtime.Executable
Default Public ReadOnly Property Item(index As Object) As Executable

Parametri

index
Object

Indice dell'oggetto Executable che deve essere restituito.

Valore della proprietà

Oggetto Executable della raccolta.

Esempio

L'esempio seguente è una modifica dell'esempio trovato in Remove. Rimuove il file eseguibile usando la sintassi dell'elemento.

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

namespace Executables_API  
{  
        class Program  
        {  
                static void Main(string[] args)  
                {  
                    Executable exec = pkg.Executables.Add("STOCK:BulkInsertTask");  
                    TaskHost myTask = exec as TaskHost;  
                    BulkInsertTask myBI = myTask.InnerObject as BulkInsertTask;  
                    myBI.DebugMode = false;  
                    myBI.CheckConstraints = false;  
                    myBI.KeepIdentity = true;  

                    // Obtain the collection.  
                    Executables pgkExecs = pkg.Executables;  
                    // Show the number of executables in the collection.  
                    Console.WriteLine("The first package contains {0} executables", pgkExecs.Count);  

                    // It is a requirement to Remove the task from the  
                    // existing package before adding it to the new package.  
                    // Remove the exectuable using the Executables[x] item syntax.   
                    DtsContainer c = (DtsContainer)pkg.Executables[0];  
                    pkg.Executables.Remove(c);  

                    // Show the number of executables in the collection afterwards.  
                    Console.WriteLine("The first package now contains {0} executables", pgkExecs.Count);  

                    Package pkg2 = new Package();  
                    Executables p2Execs = pkg2.Executables;  
                    // Show the number of executables in the second collection.  
                    Console.WriteLine("The second package initially contains {0} executables", p2Execs.Count);  
                    // Join the task from pkg to pkg2.  
                    pkg2.Executables.Join(myTask);  
                    // Show the number of executables in the second collection after Join.  
                    Console.WriteLine("The second package now contains {0} executables", p2Execs.Count);  

        }  
    }  
}  
Imports System  
Imports System.Collections.Generic  
Imports System.Text  
Imports Microsoft.SqlServer.Dts.Runtime  
Imports Microsoft.SqlServer.Dts.Tasks.BulkInsertTask  

Namespace Executables_API  
        Class Program  
                Shared  Sub Main(ByVal args() As String)  
                    Dim exec As Executable =  pkg.Executables.Add("STOCK:BulkInsertTask")   
                    Dim myTask As TaskHost =  exec as TaskHost   
                    Dim myBI As BulkInsertTask =  myTask.InnerObject as BulkInsertTask   
                    myBI.DebugMode = False  
                    myBI.CheckConstraints = False  
                    myBI.KeepIdentity = True  

                    ' Obtain the collection.  
                    Dim pgkExecs As Executables =  pkg.Executables   
                    ' Show the number of executables in the collection.  
                    Console.WriteLine("The first package contains {0} executables", pgkExecs.Count)  

                    ' It is a requirement to Remove the task from the  
                    ' existing package before adding it to the new package.  
                    ' Remove the exectuable using the Executables[x] item syntax.   
                    Dim c As DtsContainer = CType(pkg.Executables(0), DtsContainer)  
                    pkg.Executables.Remove(c)  

                    ' Show the number of executables in the collection afterwards.  
                    Console.WriteLine("The first package now contains {0} executables", pgkExecs.Count)  

                    Dim pkg2 As Package =  New Package()   
                    Dim p2Execs As Executables =  pkg2.Executables   
                    ' Show the number of executables in the second collection.  
                    Console.WriteLine("The second package initially contains {0} executables", p2Execs.Count)  
                    ' Join the task from pkg to pkg2.  
                    pkg2.Executables.Join(myTask)  
                    ' Show the number of executables in the second collection after Join.  
                    Console.WriteLine("The second package now contains {0} executables", p2Execs.Count)  

                End Sub  
        End Class  
End Namespace  

Esempio di output

The first package contains 1 executables

The first package now contains 0 executables

The second package initially contains 0 executables

The second package now contains 1 executables

Commenti

Se la chiamata al Contains metodo restituisce true, è possibile accedere all'elemento specificato nella raccolta usando la sintassi Executables[index]. Se restituisce false, questa proprietà genera un'eccezioneContains. In C#, questa proprietà è l'indicizzatore per la classe Executables.

Si applica a