学习Anlysis-1

最新推荐文章于 2024-05-13 16:06:33 发布

想改行的程序员

最新推荐文章于 2024-05-13 16:06:33 发布

阅读量311

点赞数

文章标签： string exception command class cmd null

本文链接：https://blog.csdn.net/xinfengmile/article/details/2780177

版权

ADOMD 查询备忘：添加AnalysisServices.AdomdClient的引用

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.AnalysisServices.AdomdClient;
namespace ana_progrom_learn
{
    class Program
    {
        static void Main(string[] args)
        {
            string constr = "Data Source =ncutxin;Catalog=XMPS";
            AdomdConnection con = new AdomdConnection(constr);
            AdomdCommand cmd = new AdomdCommand();
            cmd.Connection = con;
            cmd.CommandType = System.Data.CommandType.Text;
            cmd.CommandText = "select ([Measures].[Sqje]) On COLUMNS,([t Isort].[Lbnote].Members) ON ROWS From XMPS";//you command
            con.Open();
            AdomdDataReader mr = cmd.ExecuteReader();
            //mr.NextResult();
            for (int j = 0; j < mr.FieldCount; j++)
            {
                string tm;
                Console.WriteLine((tm=mr.GetName(j)) == null ? "Exp" : tm);
            }
            mr.Read();
            for (int i = 0; i < 10; i++)
            {
                for (int j = 0; j < mr.FieldCount; j++)
                {
                    try
                    {
                        Console.WriteLine(mr.GetValue(j).ToString());
                    }catch(Exception){
                        Console.WriteLine("Exp");
                    }
                }
                Console.WriteLine();
                //mr.NextResult();
                if(!mr.Read()) break;
            }

        }
    }
}