Partager via


Classe CellCollection

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

Hiérarchie d'héritage

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

Espace de noms :  Microsoft.AnalysisServices.AdomdClient
Assembly :  Microsoft.AnalysisServices.AdomdClient (en Microsoft.AnalysisServices.AdomdClient.dll)

Syntaxe

'Déclaration
Public NotInheritable Class CellCollection _
    Implements ICollection, IEnumerable
'Utilisation
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

Le type CellCollection expose les membres suivants.

Propriétés

  Nom Description
Propriété publique Count Gets the number of Cell objects in the collection.
Propriété publique IsSynchronized Gets a value indicating whether access to the collection is synchronized (thread safe).
Propriété publique 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.
Propriété publique 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.
Propriété publique Item[ ( [ ( array<Int32> [] () [] []] ) ] ) Gets the specified Cell from the collection by an array of absolute axis indexes.
Propriété publique Item[ ( [ ( Int32, Int32] ) ] ) Gets the specified Cell from the collection by its coordinate.
Propriété publique SyncRoot Gets an object that can be used to synchronize access to the collection.

Haut de la page

Méthodes

  Nom Description
Méthode publique CopyTo Copies the elements of the collection to the specified array.
Méthode publique Equals (hérité de Object.)
Méthode protégée Finalize (hérité de Object.)
Méthode publique GetEnumerator Gets an enumerator for iterating through the collection.
Méthode publique GetHashCode (hérité de Object.)
Méthode publique GetType (hérité de Object.)
Méthode protégée MemberwiseClone (hérité de Object.)
Méthode publique ToString (hérité de Object.)

Haut de la page

Implémentations d'interfaces explicites

  Nom Description
Implémentation d'interface expliciteMéthode privée ICollection. . :: . .CopyTo
Implémentation d'interface expliciteMéthode privée IEnumerable. . :: . .GetEnumerator

Haut de la page

Exemples

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

Sécurité des threads

Tous les membres publics static (Shared dans Visual Basic) de ce type sont thread-safe. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.