Executables.Item[Object] Properti

Definisi

Ruang nama:

Microsoft.SqlServer.Dts.Runtime

Rakitan:

Microsoft.SqlServer.ManagedDTS.dll

Executable Mendapatkan objek dari koleksi.

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

Parameter

index

Object

Indeks objek yang akan Executable dikembalikan.

Nilai Properti

Executable

Objek Executable dari koleksi.

Contoh

Contoh berikut adalah modifikasi sampel yang ditemukan di Hapus. Ini menghapus executable menggunakan sintaks item.

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  

Contoh 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

Keterangan

Jika panggilan ke Contains metode mengembalikan true, Anda dapat mengakses elemen yang ditentukan dalam koleksi dengan menggunakan sintaks Executables[index]. Jika mengembalikan Containsfalse, properti ini memberikan pengecualian. Di C#, properti ini adalah pengindeks Executables untuk kelas .