DTSReadOnlyCollectionBase.Count Eigenschaft
Definition
Wichtig
Einige Informationen beziehen sich auf Vorabversionen, die vor dem Release ggf. grundlegend überarbeitet werden. Microsoft übernimmt hinsichtlich der hier bereitgestellten Informationen keine Gewährleistungen, seien sie ausdrücklich oder konkludent.
Ruft die Anzahl der in der DTSReadOnlyCollectionBase-Instanz enthaltenen Elemente ab.
public:
property int Count { int get(); };
public int Count { get; }
member this.Count : int
Public ReadOnly Property Count As Integer
Eigenschaftswert
Eine ganze Zahl, die die Anzahl der in der DTSReadOnlyCollectionBase-Instanz enthaltenen Elemente enthält.
Implementiert
Beispiele
Im folgenden Codebeispiel wird gezeigt, wie eine erbende Klasse, die LogProviders Auflistung, die Count Eigenschaft verwendet.
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
namespace LogProviders_Tests
{
class Program
{
static void Main(string[] args)
{
// The package is one of the SSIS Samples.
string mySample = @"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx";
// Create the Application, and load the sample.
Application app = new Application();
Package pkg = app.LoadPackage(mySample, null);
LogProviders logProvs = pkg.LogProviders;
// Count the number of providers in the package.
int countProvs = logProvs.Count;
Console.WriteLine("Initial number of log providers: {0}", countProvs);
// Since the package that was loaded only contained the
// SSIS Log provider for Text files, let's add the SQL
// Server log provider.
LogProvider logProv = pkg.LogProviders.Add("DTS.LogProviderSQLServer.1");
// Count how many log providers are in the collection now.
countProvs = logProvs.Count;
Console.WriteLine("The number of log providers now: {0}", countProvs);
Console.WriteLine("----------------------------");
foreach (LogProvider lp in logProvs)
{
Console.WriteLine("Log Provider Name: {0}", lp.Name);
}
}
}
}
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Namespace LogProviders_Tests
Class Program
Shared Sub Main(ByVal args() As String)
' The package is one of the SSIS Samples.
Dim mySample As String = "C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx"
' Create the Application, and load the sample.
Dim app As Application = New Application()
Dim pkg As Package = app.LoadPackage(mySample,Nothing)
Dim logProvs As LogProviders = pkg.LogProviders
' Count the number of providers in the package.
Dim countProvs As Integer = logProvs.Count
Console.WriteLine("Initial number of log providers: {0}", countProvs)
' Since the package that was loaded only contained the
' SSIS Log provider for Text files, let's add the SQL
' Server log provider.
Dim logProv As LogProvider = pkg.LogProviders.Add("DTS.LogProviderSQLServer.1")
' Count how many log providers are in the collection now.
countProvs = logProvs.Count
Console.WriteLine("The number of log providers now: {0}", countProvs)
Console.WriteLine("----------------------------")
Dim lp As LogProvider
For Each lp In logProvs
Console.WriteLine("Log Provider Name: {0}", lp.Name)
Next
End Sub
End Class
End Namespace
Beispielausgabe:
Anfängliche Anzahl von Protokollanbietern: 1
Die Anzahl der Protokollanbieter jetzt: 2
----------------------------
Protokollanbietername: {FCA3ACD4-C080-4B67-A1AA-45118D3DA672}
Protokollanbietername: SSIS-Protokollanbieter für Textdateien