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

• Previous message: peter_zhang: "use ADOMD .net to get KPI"
• In reply to: Zhang JiDong: "Help! how to get the content of each cell in a CellSet?"
• Messages sorted by: [ date ] [ thread ]

Date: Fri, 24 Sep 2004 19:00:47 -0400

you need to loop through the cellset, using an indexer to get the content.
look throught the following c# code

                        int[] cellIndex = new int[cells.Axes.Count];
                        for (int i = 0; i < cells.Axes[1].Positions.Count; i++)
                        {
                                cellIndex.SetValue(i, 1);
                                DataRow r = tbl.NewRow();
                                r[0] = cells.Axes[1].Positions[i].Members[0].Caption;
                                for (int j = 0; j < cells.Axes[0].Positions.Count; j++)
                                {
                                        cellIndex.SetValue(j,0);
                                        // first axis. create a datarow, add the id column for the datarow,
finally add row to table
                                        r[j+1] = cells.Cells[cellIndex].Value;
                                }
                                tbl.Rows.Add(r);
                        }

• Previous message: peter_zhang: "use ADOMD .net to get KPI"
• In reply to: Zhang JiDong: "Help! how to get the content of each cell in a CellSet?"
• Messages sorted by: [ date ] [ thread ]