Help! how to get the content of each cell in a CellSet?

From: Zhang JiDong (jdzhang_at_iflytek.com)
Date: 09/24/04

  • Next message: Akshai Mirchandani [MS]: "Re: Help! how to get the content of each cell in a CellSet?" 
    Date: Fri, 24 Sep 2004 15:13:40 +0800

    hi,
       In ASP.NET + OLAP + ADOMD, I wrote codes as follows:
        (I don't know how to get the content of each cell in a CellSet)

       ADODB.Connection oDB = new ADODB.Connection();
       ADOMD.Cellset oMDCS = new ADOMD.Cellset();
       oDB.Open("provider=msolap;data source=localhost","", "", 0);
       oDB.DefaultDatabase = "Foodmart 2000";

       oMDCS.ActiveConnection = oDB;

       string szMDX = "SELECT {[Measures].members} ON COLUMNS, NON EMPTY
    [Store].[Store City].members ON ROWS FROM Sales";
       oMDCS.Open(szMDX, oDB);

        // How to get the content of each cell in the oMDCS ???

  • Next message: Akshai Mirchandani [MS]: "Re: Help! how to get the content of each cell in a CellSet?"

    Relevant Pages

    • Re: Help! how to get the content of each cell in a CellSet?
      ... accessing cells in an ADOMD cellset in C# turns out to have a slightly ... single element containing the cell ordinal of the required cell, ... > ADODB.Connection oDB = new ADODB.Connection; ... // How to get the content of each cell in the oMDCS ??? ...
      (microsoft.public.data.xmlanalysis)
    • CellSetGrid and DrillThrough
      ... clicking the cell values in the UI. ... but I am uncertain about building the MDX for the DrillThrough. ... On the callback, ... I have a reference to the correct cell in the cellset. ...
      (microsoft.public.sqlserver.olap)
    • Re: ADOMD.net accessing >1 dimension
      ... ADOMD.NET contains 3 different ways to access cell in the cellset ... By cell ordinal - this is the method you described below - CellSet(int ... > Dim conADOMD As New AdomdConnection("Data ... > Dim posFMRow As Position, posFMCol As Position, pos as Long ...
      (microsoft.public.data.xmlanalysis)
    • Re: ADOMD.net accessing >1 dimension
      ... ADOMD.NET contains 3 different ways to access cell in the cellset ... By cell ordinal - this is the method you described below - CellSet(int ... > Dim conADOMD As New AdomdConnection("Data ... > Dim posFMRow As Position, posFMCol As Position, pos as Long ...
      (microsoft.public.sqlserver.olap)
    • Re: ADOMD.net accessing >1 dimension
      ... ADOMD.NET contains 3 different ways to access cell in the cellset ... By cell ordinal - this is the method you described below - CellSet(int ... > Dim conADOMD As New AdomdConnection("Data ... > Dim posFMRow As Position, posFMCol As Position, pos as Long ...
      (microsoft.public.sqlserver.olap)
    Loading