Condividi tramite


Classe CellCollection

Contains a read-only collection of Cell objects contained by a CellSet.

Gerarchia di ereditarietà

System. . :: . .Object
  Microsoft.AnalysisServices.AdomdClient..::..CellCollection

Spazio dei nomi  Microsoft.AnalysisServices.AdomdClient
Assembly:  Microsoft.AnalysisServices.AdomdClient (in Microsoft.AnalysisServices.AdomdClient.dll)

Sintassi

'Dichiarazione
Public NotInheritable Class CellCollection _
    Implements ICollection, IEnumerable
'Utilizzo
Dim instance As CellCollection
public sealed class CellCollection : ICollection, 
    IEnumerable
public ref class CellCollection sealed : ICollection, 
    IEnumerable
[<SealedAttribute>]
type CellCollection =  
    class
        interface ICollection
        interface IEnumerable
    end
public final class CellCollection implements ICollection, IEnumerable

Nel tipo CellCollection sono esposti i membri seguenti.

Proprietà

  Nome Descrizione
Proprietà pubblica Count Gets the number of Cell objects in the collection.
Proprietà pubblica IsSynchronized Gets a value indicating whether access to the collection is synchronized (thread safe).
Proprietà pubblica Item[ ( [ ( ICollection] ) ] ) Gets the specified Cell from the collection by an ICollection interface that contains a collection of absolute axis indexes. In Microsoft Visual C#, this property is the indexer for the CellCollection class.
Proprietà pubblica Item[ ( [ ( Int32] ) ] ) Gets the specified Cell from the collection by its index. In Microsoft Visual C#, this property is the indexer for the CellCollection class.
Proprietà pubblica Item[ ( [ ( array<Int32> [] () [] []] ) ] ) Gets the specified Cell from the collection by an array of absolute axis indexes.
Proprietà pubblica Item[ ( [ ( Int32, Int32] ) ] ) Gets the specified Cell from the collection by its coordinate.
Proprietà pubblica SyncRoot Gets an object that can be used to synchronize access to the collection.

In alto

Metodi

  Nome Descrizione
Metodo pubblico CopyTo Copies the elements of the collection to the specified array.
Metodo pubblico Equals Ereditato da Object.
Metodo protetto Finalize Ereditato da Object.
Metodo pubblico GetEnumerator Gets an enumerator for iterating through the collection.
Metodo pubblico GetHashCode Ereditato da Object.
Metodo pubblico GetType Ereditato da Object.
Metodo protetto MemberwiseClone Ereditato da Object.
Metodo pubblico ToString Ereditato da Object.

In alto

Implementazioni esplicite dell'interfaccia

  Nome Descrizione
Implementazione esplicita dell'interfacciaMetodo privato ICollection. . :: . .CopyTo
Implementazione esplicita dell'interfacciaMetodo privato IEnumerable. . :: . .GetEnumerator

In alto

Esempi

The following subroutine, given a CellSet and the number of cells for which to display information, iterates through the CellCollection collection and displays information for each cell:

Public Sub ListCellCollection(ByRef CellSetToCheck As CellSet, _
    Optional ByVal Count As Integer = 10)

    ' Because cellsets can represent tens of thousands of cells,
    ' the Count parameter limits the output to a 
    ' specified number of cells.

    If CellSetToCheck Is Nothing Then
        Throw New System.ArgumentNullException("CellSetToCheck")
    Else
        ' Iterate through the Hierarchies collection of the
        ' Dimension object.

        Dim cellToCheck As Cell
        Dim cellCount As Long
        Dim cellIndex As Long

        Try
            cellCount = CellSetToCheck.CellCollection.Count
            Debug.WriteLine("Found " & cellCount & _
                " cell(s) in cellset:")

            If cellCount > Count Then cellCount = Count

            If cellCount > 0 Then
                For cellIndex = 0 To cellCount - 1
                    cellToCheck = CellSetToCheck.CellCollection(cellIndex)

                    Debug.WriteLine("  Value:           " & _
                        cellToCheck.Value)
                    Debug.WriteLine("  -- Formatting Properties --")
                    Debug.WriteLine("  BackColor:" & _
                        cellToCheck.CellProperties("BackColor"))
                    Debug.WriteLine("  ForeColor:" & _
                        cellToCheck.CellProperties("ForeColor"))
                    Debug.WriteLine("  FormatString:    " & _
                        cellToCheck.CellProperties("FormatString"))
                    Debug.WriteLine("  FormattedValue:  " & _
                        cellToCheck.FormattedValue)
                Next
            End If
        Catch ex As AdomdConnectionException
            ' The connection could not be opened or was disconnected.
            ' This error can occur at any time, if the provider is 
            ' disconnected from the server.
            Debug.WriteLine(ex)
        Catch ex As AdomdErrorResponseException
            ' A response is received from a provider which indicates an error.
            Debug.WriteLine(ex)
        Catch ex As AdomdUnknownResponseException
            ' A response has been returned from the provider that 
            ' was not understood.
            Debug.WriteLine(ex)
        Catch ex As AdomdCacheExpiredException
            ' A cached version of an ADOMD.NET object is no longer valid.
            ' This error is typically raised when reviewing metadata.
            Debug.WriteLine(ex)
        Catch ex As AdomdException
            ' Any other error raised by ADOMD.NET.
            Debug.WriteLine(ex)
        Catch ex As Exception
            ' Any other error.
            Debug.WriteLine(ex)
        End Try
    End If
End Sub

Protezione dei thread

I membri static (Shared in Visual Basic) pubblici di questo tipo sono affidabili. Non è invece garantita la sicurezza dei membri dell'istanza.