Cellset Object (ADO MD)

   Example   Collections   Properties   Methods   

A Cellset represents the results of a multidimensional query.

Remarks

Data within a Cellset is retrieved using direct, array-like access. There is no notion of currency within a Cellset. The Item method retrieves a Cell object corresponding to the Axis position specified.

With the collections, methods, and properties of a Cellset object, you can do the following:

• Return or specify the query used to define the Cellset with the Source property.
  
  
• Execute and retrieve the results of a multidimensional query with the Open method.
  
  
• Retrieve a Cell from the Cellset with the Item method.
  
  
• Return the Axis objects that define the Cellset with the Axes collection.
  
  
• Retrieve information on the dimensions used to filter the data in the Cellset with the FilterAxis property.
  
  
• Associate an open connection with a Cellset object by setting its ActiveConnection property.
  
  
• Close an open Cellset with the Close method.
  
  
• Return the current state of the Cellset (Open, Closed, Executing, or Connecting) with the State property.