dashboard 数据绑定的时候 addTable 是视图

            MsSqlConnectionParameters ms = new MsSqlConnectionParameters();
            ms.AuthorizationType = MsSqlAuthorizationType.SqlServer;
            ms.Password = "**";
            ms.UserName = "sa";
            ms.ServerName = "localhost";
            ms.DatabaseName = "**";
            //  ms.AuthorizationType = MsSqlAuthorizationType.SqlServer;
            DashboardSqlDataSource sqlDataSource1 = new DashboardSqlDataSource("SQL Data Source 1", ms);
            TableQuery tableQuery1 = new TableQuery("Query 1");
            tableQuery1.AddTable("dyhjjzb【视图】").SelectColumns("xmdm", "hzsl", "xmlx", "zyh");
            sqlDataSource1.Queries.Add(tableQuery1);
            sqlDataSource1.Fill();
            dashboardDesigner1.Dashboard.DataSources.Add(sqlDataSource1);

  

posted @ 2016-10-06 16:40  刀小爱  阅读(425)  评论(0编辑  收藏  举报