如何在c# winform 下连接SQL SERVER的OLAP多维数据集 如何在c# winform下连接SQL SERVER的OLAP多维数据集 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 OleDbConnection myConn = new System.Data.OleDb.OleDbConnection(); myConn.ConnectionString = "Provider=MSOLAP.1;Data Source=LOCALHOST;Location=FoodMart 2000;Initial Catalog=FoodMart 2000;"; 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(); 串口通信 系统问题 context.items.add()这个内容在什么情况下用呀? c# ? 为什么ComboBox中不管怎么样都得不到selectedvalue的值? 疑问解答? 关于数型的中英文切换 如何实现选中listview中记录,在控件框中自动关联显示出记录? 紧张求助!!! 我制作了一个控件,可是没法引用? 关于在页面中插入FLASH的问题 JS传参数 谢谢大家帮忙
myConn.ConnectionString = "Provider=MSOLAP.1;Data Source=LOCALHOST;Location=FoodMart 2000;Initial Catalog=FoodMart 2000;";
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();