Variables.Remove(Object) メソッド

定義

名前空間:

Microsoft.SqlServer.Dts.Runtime

アセンブリ:

Microsoft.SqlServer.ManagedDTS.dll

Variable オブジェクトを Variables コレクションから削除します。

public:
 void Remove(System::Object ^ index);

public void Remove (object index);

member this.Remove : obj -> unit

Public Sub Remove (index As Object)

パラメーター

index

Object

コレクションから削除する Variable オブジェクトの名前、ID、説明、またはインデックスです。

例

次のコード例では、変数を空のパッケージに追加します。 変数の名前 myCustomVarは、値 3 が与えられ、 User 名前空間にあります。 次に、Remove メソッドを使用して、この変数が削除されます。

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

namespace Add_Remove_Vars  
{  
    class Program  
    {  
        static void Main(string[] args)  
        {  
            Package pkg = new Package();  
            Variables pkgVars = pkg.Variables;  
            Variable myVar = pkg.Variables.Add("myCustomVar", false, "User", "3");  

            // Verify whether the variable is in the collection now.  
            Boolean hasMyVar = pkg.Variables.Contains("myCustomVar");  
            Console.WriteLine("The variable was found? {0}", hasMyVar);  

            Console.WriteLine("---------------------------");  
            // Loop over the collection using the foreach keyword.  
            foreach (Variable pkgVar in pkgVars)  
            {  
                // Print variables only from the User namespace.  
                if (pkgVar.Namespace == "User")  
                {  
                Console.WriteLine("Variable: {0}, {1}", pkgVar.Name, pkgVar.Value.ToString());  
                 }  
            }  
            Console.WriteLine("---------------------------");  
            // Remove the variable from the namespace.  
            pkg.Variables.Remove("myCustomVar");  

            // Loop over the collection again.  
            foreach (Variable pkgVar in pkgVars)  
            {  
                // Print variables only from the User namespace. Nothing should show.  
                if (pkgVar.Namespace == "User")  
                {  
                    Console.WriteLine("Variable: {0}, {1}", pkgVar.Name, pkgVar.Value.ToString());  
                }  
            }  
            Console.WriteLine("---------------------------");  
            Console.WriteLine("");  
        }  
    }  
}  

Imports System  
Imports System.Collections.Generic  
Imports System.Text  
Imports Microsoft.SqlServer.Dts.Runtime  

Namespace Add_Remove_Vars  
    Class Program  
        Shared  Sub Main(ByVal args() As String)  
            Dim pkg As Package =  New Package()   
            Dim pkgVars As Variables =  pkg.Variables   
            Dim myVar As Variable =  pkg.Variables.Add("myCustomVar",False,"User","3")   

            ' Verify whether the variable is in the collection now.  
            Dim hasMyVar As Boolean =  pkg.Variables.Contains("myCustomVar")   
            Console.WriteLine("The variable was found? {0}", hasMyVar)  

            Console.WriteLine("---------------------------")  
            ' Loop over the collection using the foreach keyword.  
            Dim pkgVar As Variable  
            For Each pkgVar In pkgVars  
                ' Print variables only from the User namespace.  
                If pkgVar.Namespace = "User" Then  
                Console.WriteLine("Variable: {0}, {1}", pkgVar.Name, pkgVar.Value.ToString())  
                End If  
            Next  
            Console.WriteLine("---------------------------")  
            ' Remove the variable from the namespace.  
            pkg.Variables.Remove("myCustomVar")  

            ' Loop over the collection again.  
            Dim pkgVar As Variable  
            For Each pkgVar In pkgVars  
                ' Print variables only from the User namespace. Nothing should show.  
                If pkgVar.Namespace = "User" Then  
                    Console.WriteLine("Variable: {0}, {1}", pkgVar.Name, pkgVar.Value.ToString())  
                End If  
            Next  
            Console.WriteLine("---------------------------")  
            Console.WriteLine("")  
        End Sub  
    End Class  
End Namespace  

サンプル出力:

The variable was found? True

---------------------------

Variable: myCustomVar, 3

---------------------------

---------------------------