01.public void Page_Load(object sender, EventArgs e)
02. {
03.
04. string cnstr1= "Provider=MSOLAP;"
05. +"Persist Security Info=false;"
06. +"Data Source=local;"
07. +"Initial Catalog=TEST;";
08.
09. System.Text.StringBuilder result = new System.Text.StringBuilder();
10. AdomdConnection conn = new AdomdConnection(cnstr1);
11. {
12. conn.Open();
13. AdomdCommand cmd = conn.CreateCommand();
14. cmd.CommandText = @"SELECT {[a].} on columns,{[c].[d]} on rows from [subtest]";
15.
16. CellSet cs = cmd.ExecuteCellSet();
17.
18. result.Append("\t\t\t");
19.
20. TupleCollection tuplesOnColumns = cs.Axes[0].Set.Tuples;
21.
22. foreach (Microsoft.AnalysisServices.AdomdClient.Tuple column in tuplesOnColumns)
23. {
24. result.Append(column.Members[0].Caption + "\t");
25.
26. }
27. result.AppendLine();
28.
29. TupleCollection tuplesOnRows = cs.Axes[1].Set.Tuples;
30. for (int row = 0; row < tuplesOnRows.Count; row++)
31. {
32. for (int members = 0; members < tuplesOnRows[row].Members.Count; members++ )
33. {
34. result.Append(tuplesOnRows[row].Members[members].Caption + "\t");
35. }
36.
37. for (int col = 0; col < tuplesOnColumns.Count; col++)
38. {
39. result.Append(cs.Cells[col, row].FormattedValue + "\t");
40. }
41. result.AppendLine();
42. }
43. conn.Close();
44.
45. lblText.Text = result.ToString();
46. }
47. }
Quote:
