using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Microsoft.AnalysisServices.AdomdClient;
namespace winAl
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
public void Adomd()
{
//连接的字符串
string conStr = "provider=msolap ;Integrated Security =SSPI ;Data Source= localhost ;Catalog =Analysis Services Tutorial ;";
//创建个连接对象
AdomdConnection con = new AdomdConnection();
con.ConnectionString = conStr;
con.Open();
// 创建个命令
AdomdCommand cmm =con.CreateCommand();
cmm.CommandText = @" select {[Measures].[Reseller Sales-Sales Amount] ,[Measures].[Sales Amount Quota] } on columns,
{[Date].[Fiscal Quarter].Members} on rows
from [Analysis Services Tutorial]
where [Date].[Fiscal Year].&[2004]";
//执行命令返回单元集合
CellSet result = cmm.ExecuteCellSet();
this.dataGridView1.DataSource = CellSetToTable(result);
con.Close();
} private DataTable CellSetToTable(CellSet cellset)
{
DataTable table = new DataTable("cellset");
Axis columns=cellset.Axes[0] ;//获取列轴
Axis rows=cellset.Axes[1] ; //获取行轴
CellCollection valuesCell = cellset.Cells;//获取度量值单元集合
//行轴的级别标题为表的第一列
table.Columns.Add(rows.Set.Hierarchies[0].Caption);
//行轴的成各个成员的标题变成表的列
for(int i=0 ;i<columns.Set.Tuples.Count ;i++)
{
table.Columns.Add(new DataColumn(columns.Set.Tuples[i].Members[0].Caption)) ;
}
int valuesIndex=0;
DataRow row = null;
//向表中填充数据
for (int i = 0; i < rows.Set.Tuples.Count;i++ )
{
row = table.NewRow();
//表所有行的第一列值为相应行轴的成标题
row[0] = rows.Set.Tuples[i].Members[0].Caption;
for (int k = 1; k <= columns.Set.Tuples.Count;k++ )
{ //按顺序把度量值单元集合的值填充到表中
row[k] = valuesCell[valuesIndex].Value;
valuesIndex++;
}
table.Rows.Add(row);
} return table;
} private void button1_Click(object sender, EventArgs e)
{
Adomd();
}
}
}
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Microsoft.AnalysisServices.AdomdClient;
namespace winAl
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
public void Adomd()
{
//连接的字符串
string conStr = "provider=msolap ;Integrated Security =SSPI ;Data Source= localhost ;Catalog =Analysis Services Tutorial ;";
//创建个连接对象
AdomdConnection con = new AdomdConnection();
con.ConnectionString = conStr;
con.Open();
// 创建个命令
AdomdCommand cmm =con.CreateCommand();
cmm.CommandText = @" select {[Measures].[Reseller Sales-Sales Amount] ,[Measures].[Sales Amount Quota] } on columns,
{[Date].[Fiscal Quarter].Members} on rows
from [Analysis Services Tutorial]
where [Date].[Fiscal Year].&[2004]";
//执行命令返回单元集合
CellSet result = cmm.ExecuteCellSet();
this.dataGridView1.DataSource = CellSetToTable(result);
con.Close();
} private DataTable CellSetToTable(CellSet cellset)
{
DataTable table = new DataTable("cellset");
Axis columns=cellset.Axes[0] ;//获取列轴
Axis rows=cellset.Axes[1] ; //获取行轴
CellCollection valuesCell = cellset.Cells;//获取度量值单元集合
//行轴的级别标题为表的第一列
table.Columns.Add(rows.Set.Hierarchies[0].Caption);
//行轴的成各个成员的标题变成表的列
for(int i=0 ;i<columns.Set.Tuples.Count ;i++)
{
table.Columns.Add(new DataColumn(columns.Set.Tuples[i].Members[0].Caption)) ;
}
int valuesIndex=0;
DataRow row = null;
//向表中填充数据
for (int i = 0; i < rows.Set.Tuples.Count;i++ )
{
row = table.NewRow();
//表所有行的第一列值为相应行轴的成标题
row[0] = rows.Set.Tuples[i].Members[0].Caption;
for (int k = 1; k <= columns.Set.Tuples.Count;k++ )
{ //按顺序把度量值单元集合的值填充到表中
row[k] = valuesCell[valuesIndex].Value;
valuesIndex++;
}
table.Rows.Add(row);
} return table;
} private void button1_Click(object sender, EventArgs e)
{
Adomd();
}
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货