如何在c# winform 下连接SQL SERVER的OLAP多维数据集

[zhujiazhao123]

如何在c# winform下连接SQL SERVER的OLAP多维数据集

[zhujiazhao123]

怎么每人啊，啊啊啊啊啊啊啊啊啊啊啊啊

[zzyhuian06142]

OleDbConnection myConn = new System.Data.OleDb.OleDbConnection();
myConn.ConnectionString = "Provider=MSOLAP.1;Data Source=LOCALHOST;Location=FoodMart 2000;Initial Catalog=FoodMart 2000;";

[zzyhuian06142]

string strConn = " Provider=MSOLAP.2;Data Source=192.168.0.36;User ID=sa;Initial Catalog=mini";
OleDbConnection OleDbConn = new OleDbConnection(strConn);
OleDbConn.Open();
//Response.Write("当前OleDbConn的状态" + OleDbConn.State.ToString());

//string strComm = "select * from payList";

string strComm = "SELECT [familyList:Family Id!KEY] AS 家庭编号, ";
strComm += " [familyList:Cy Id!NAME] AS 家庭成员, ";
strComm += " [dateList:月!KEY] AS 购物月份, [dateList:日!KEY] AS 购物日期, ";
strComm += " [superMList:Super M Name!KEY] AS 购物地点, [Measures:Pay Price] AS 购物支出 ";
strComm += " FROM payList ";

OleDbDataAdapter da = new OleDbDataAdapter(strComm, OleDbConn);
DataSet ds = new DataSet();
da.Fill(ds);

this.GridView1.DataSource = ds;
this.GridView1.DataBind();

[zhujiazhao123]

我是用pivottable的

[zhujiazhao123]

顶一下。。。。。。。。。。。。。。。。。。。。。