dmxadhoc.aspx.cs

< SQL Server2005程序设计>

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Microsoft.AnalysisServices.AdomdClient;

public partial class DMXViewer : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btnExecute_Click(object sender, EventArgs e)
    {
        AdomdConnection conn = new AdomdConnection("Data Source=" + txtServer.Text + ";Initial Catalog=" + ddlCatalogs.Text);
        AdomdCommand cmd = new AdomdCommand(txtQuery.Text, conn);
        AdomdDataAdapter da = new AdomdDataAdapter(cmd);
        
        DataTable dt = new DataTable();
        da.Fill(dt);
        gvResults.DataSource = dt;
        gvResults.DataBind();
    }
    protected void btnGetCatalogs_Click(object sender, EventArgs e)
    {
        AdomdConnection conn = new AdomdConnection("Data Source=" + txtServer.Text);
        conn.Open();
        foreach (DataRow dr in conn.GetSchemaDataSet(AdomdSchemaGuid.Catalogs, null).Tables[0].Rows)
        {
            ddlCatalogs.Items.Add((string)dr[0]);
        }
        lblCatalogs.Visible = true;
        ddlCatalogs.Visible = true;
        conn.Close();
        btnExecute.Enabled = true;
    }
}