CellCollection 類別

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

繼承階層

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

命名空間：  Microsoft.AnalysisServices.AdomdClient
組件：  Microsoft.AnalysisServices.AdomdClient (在 Microsoft.AnalysisServices.AdomdClient.dll 中)

語法

'宣告
Public NotInheritable Class CellCollection _
    Implements ICollection, IEnumerable
'用途
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

CellCollection 型別公開下列成員。

屬性

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

上層

方法

	名稱	說明
	CopyTo	Copies the elements of the collection to the specified array.
	Equals	(繼承自 Object。)
	Finalize	(繼承自 Object。)
	GetEnumerator	Gets an enumerator for iterating through the collection.
	GetHashCode	(繼承自 Object。)
	GetType	(繼承自 Object。)
	MemberwiseClone	(繼承自 Object。)
	ToString	(繼承自 Object。)

上層

明確 繼承 實作

	名稱	說明
	ICollection. . :: . .CopyTo
	IEnumerable. . :: . .GetEnumerator

上層

範例

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

執行緒安全性

這個型別的任何公用 static (在 Visual Basic 中為 Shared) 成員都是執行緒安全的。並不是所有的執行個體成員都保證可以用於所有的執行緒。

請參閱

參考

Microsoft.AnalysisServices.AdomdClient 命名空間