owcoutput.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;

public partial class OWCOutput : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request["Controltype"] == "PivotTable")
        {
            Response.Write(@"<object classid='clsid:0002E55A-0000-0000-C000-000000000046' id='PivotTable1'><param name='ConnectionString' value='Provider=MSOLAP;Data Source=" + Request["Server"] + ";Initial Catalog=" + Request["Database"] + "'><param name='DataMember' value='" + Request["Cube"] + "'><param name='DisplayFieldList' value='True' /></object>");
        }
        else
        {
            Response.Write(@"<object classid='clsid:0002E55D-0000-0000-C000-000000000046' id='PivotTable1'><param name='ConnectionString' value='Provider=MSOLAP;Data Source=" + Request["Server"] + ";Initial Catalog=" + Request["Database"] + "'><param name='DataMember' value='" + Request["Cube"] + "'><param name='DisplayFieldList' value='True' /><param name='DisplayToolbar' value='True' /><param name='AllowPropertyToolbox' value='True' /></object>");
        }
    }
}