DtsProperties.Item[Object] 屬性
定義
重要
部分資訊涉及發行前產品,在發行之前可能會有大幅修改。 Microsoft 對此處提供的資訊,不做任何明確或隱含的瑕疵擔保。
從集合中傳回 DtsProperty 物件。
public:
property Microsoft::SqlServer::Dts::Runtime::DtsProperty ^ default[System::Object ^] { Microsoft::SqlServer::Dts::Runtime::DtsProperty ^ get(System::Object ^ index); };
public Microsoft.SqlServer.Dts.Runtime.DtsProperty this[object index] { get; }
member this.Item(obj) : Microsoft.SqlServer.Dts.Runtime.DtsProperty
Default Public ReadOnly Property Item(index As Object) As DtsProperty
參數
- index
- Object
要傳回之 DtsProperty 物件的名稱、索引或識別。
屬性值
DtsProperty 物件。
範例
下列程式碼範例會使用 DtsProperties[x] 語法來抓取集合中第五個物件的名稱,以從集合中抓取專案。
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
namespace DtsProperties_API
{
class Program
{
static void Main(string[] args)
{
Package pkg = new Package();
// Get the Properties collection from the package.
// This shows the default properties set on new packages.
DtsProperties pkgProperties = pkg.Properties;
// Create the enumerator.
PropertyEnumerator myEnumerator = pkgProperties.GetEnumerator();
// Show the use of the Contains method.
Boolean containsCertObj = pkgProperties.Contains("CertificateObject");
Console.WriteLine("Contains CertificateObject? {0}", containsCertObj);
// Show the use of the item[x] syntax.
String aName = pkgProperties[5].Name;
Console.WriteLine("Property 5 is {0}", aName);
// Show the use of the MoveNext and Current methods.
int i = 0;
while ((myEnumerator.MoveNext()) && (myEnumerator.Current != null))
{
Console.WriteLine("[{0}] {1}", i++, myEnumerator.Current.Name);
}
}
}
}
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Namespace DtsProperties_API
Class Program
Shared Sub Main(ByVal args() As String)
Dim pkg As Package = New Package()
' Get the Properties collection from the package.
' This shows the default properties set on new packages.
Dim pkgProperties As DtsProperties = pkg.Properties
' Create the enumerator.
Dim myEnumerator As PropertyEnumerator = pkgProperties.GetEnumerator()
' Show the use of the Contains method.
Dim containsCertObj As Boolean = pkgProperties.Contains("CertificateObject")
Console.WriteLine("Contains CertificateObject? {0}", containsCertObj)
' Show the use of the item[x] syntax.
Dim aName As String = pkgProperties(5).Name
Console.WriteLine("Property 5 is {0}", aName)
' Show the use of the MoveNext and Current methods.
Dim i As Integer = 0
While (myEnumerator.MoveNext()) &&(myEnumerator.Current <> Nothing)
Console.WriteLine("[{0}] {1}",i = Console.WriteLine("[{0}] {1}",i + 1
End While
End Sub
End Class
End Namespace
範例輸出:
包含 CertificateObject 嗎? True
屬性5是設定
[0] CertificateCoNtext
[1] CertificateObject
[2] CheckpointFileName
[3] CheckpointUsage
[4] CheckSignatureOnLoad
[5] 設定
[6] 連接
[7] CreationDate
[8] CreationName
[9] CreatorComputerName
[10] CreatorName
[11] DelayValidation
. . .
[63] VersionGUID
[64] VersionMajor
[65] VersionMinor
[66] 警告
備註
如果方法的呼叫傳回 Contains true ,您可以使用語法來存取集合中的指定專案 DtsProperties[index] 。 如果 Contains 方法傳回 false ,則這個屬性會擲回例外狀況。 在 C# 中,這個屬性是 DtsProperties 類別的索引子。