Dela via


DtsEventHandlers.Contains Method

Returns a Boolean that indicates whether the items in the collection can be accessed by using the name, index, or ID as the index.

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

Syntax

'Declaration
Public Function Contains ( _
    index As Object _
) As Boolean
'Usage
Dim instance As DtsEventHandlers
Dim index As Object
Dim returnValue As Boolean

returnValue = instance.Contains(index)
public bool Contains(
    Object index
)
public:
bool Contains(
    Object^ index
)
member Contains : 
        index:Object -> bool 
public function Contains(
    index : Object
) : boolean

Parameters

  • index
    Type: System.Object
    The name, index, or ID of the object to find in the collection.

Return Value

Type: System.Boolean
A Boolean that indicates whether the collection can be accessed by name, index, or ID. A value of true indicates that the collection can be accessed by using the syntax DtsEventHandlers[index].
A value of false indicates that indexing cannot be used to retrieve items from the DtsEventHandlers collection.

Examples

The following code example retrieves the DtsEventHandlers collection, then uses Contains to see if the item syntax [x] can be used on the collection.

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

namespace Microsoft.SqlServer.SSIS.Samples
{
    class Program
    {
        static void Main(string[] args)
        {
            Package pkg = new Package();

            // Set up a DtsEventHandler for the OnError event of the package.
            DtsEventHandler dtsEHOE = (DtsEventHandler)pkg.EventHandlers.Add("OnError");
            DtsEventHandler dtsEHW = (DtsEventHandler)pkg.EventHandlers.Add("OnWarning");

            // Create the DtsEventHandlers collection.
            DtsEventHandlers dtsEHColls = pkg.EventHandlers;

            // Use the Contains method to see if the item[x] syntax can be used.
            Boolean dtsContains = dtsEHColls.Contains(0);
            Console.WriteLine("Item syntax can be used?  {0}", dtsContains);

            //Using the Item method syntax of [x], obtain the first entry and a name.
            DtsEventHandler dtsEHFirstEntry = dtsEHColls[0];
            String nameOfFirstItem = dtsEHColls[0].Name;

            //Print the name of the log provider object located at position [0].
            Console.WriteLine("The ID of the first event handler is: {0}", dtsEHFirstEntry.ID);
            Console.WriteLine("The Name of the first event handler is: {0}", nameOfFirstItem);
        }
    }
}
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
 
Namespace Microsoft.SqlServer.SSIS.Samples
    Class Program
        Shared  Sub Main(ByVal args() As String)
            Dim pkg As Package =  New Package() 
 
            ' Set up a DtsEventHandler for the OnError event of the package.
            Dim dtsEHOE As DtsEventHandler = CType(pkg.EventHandlers.Add("OnError"), DtsEventHandler)
            Dim dtsEHW As DtsEventHandler = CType(pkg.EventHandlers.Add("OnWarning"), DtsEventHandler)
 
            ' Create the DtsEventHandlers collection.
            Dim dtsEHColls As DtsEventHandlers =  pkg.EventHandlers 
 
            ' Use the Contains method to see if the item[x] syntax can be used.
            Dim dtsContains As Boolean =  dtsEHColls.Contains(0) 
            Console.WriteLine("Item syntax can be used?  {0}", dtsContains)
 
            'Using the Item method syntax of [x], obtain the first entry and a name.
            Dim dtsEHFirstEnTry As DtsEventHandler =  dtsEHColls(0) 
            Dim nameOfFirstItem As String =  dtsEHColls(0).Name 
 
            'Print the name of the log provider object located at position [0].
            Console.WriteLine("The ID of the first event handler is: {0}", dtsEHFirstEnTry.ID)
            Console.WriteLine("The Name of the first event handler is: {0}", nameOfFirstItem)
        End Sub
    End Class
End Namespace

Sample Output:

Item syntax can be used? True

The ID of the first event handler is: {4B9E438E-BA17-4A51-8235-3072AFF92F99}

The Name of the first event handler is: OnError