Click here to Skip to main content
Click here to Skip to main content
Articles » Database » Database » SQL Server » Downloads
 

Microsoft Analysis Services 2005: Displaying a grid using ADOMD.NET and MDX

By , 19 Aug 2008
 
ADOMDMDXSampleByHK.zip
ADOMDMDXSampleByHK
App_Data
<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>

<html>
<head runat="server">
    <title>Displaying grid using ADOMD.NET and MDX Sample By Hitesh Khatri</title>
    <link href="StyleSheet.css" rel="stylesheet" type="text/css" />
</head>
<body>
    <form id="form1" runat="server">
    <h3>The example explains how to fetch data from OLAP Cube using ADOMD.NET and MDX; and display it in the form of grid.</h3>
    <table width="800" border="0">
        <tr>
            <td>Connection String:</td>
            <td>
                <asp:TextBox ID="txtConnStr" runat="server" Width="668px"></asp:TextBox></td>
        </tr>
        <tr>
            <td>MDX</td>
            <td>
                <asp:TextBox ID="txtMDX" runat="server" Height="100px" 
                    Rows="10" Width="650px" TextMode="MultiLine"></asp:TextBox></td>
        </tr>
        <tr>
            <td></td>
            <td>
                <asp:Button ID="btnGo" runat="server" Text=" Go " OnClick="btnGo_Click" /></td>
        </tr>
        <tr>
            <td colspan="2">
                <asp:Label ID="lblErr" runat="server" ForeColor="Red"></asp:Label></td>
        </tr>
    </table>
    <asp:Panel ID="gridPanel" runat="server"  CssClass="gridPanel">
    </asp:Panel>
    </form>
    <p>Copyright &copy; 2008 <a href="mailto:hiteshkhatri@yahoo.com">Hitesh Khatri</a><br />
    Please read the <a href="javascript:window.showModalDialog('disclaimer.htm','','dialogWidth:450px;dialogHeight:350px;center:yes;resizable:no;scroll:no;status:no')">disclaimer</a> before using this sample</p>   
</body>
</html>

By viewing downloads associated with this article you agree to the Terms of use and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

khatri.hitesh
Architect Nexvisionix Inc.
India India
Member
Click here to email Hitesh
 
Hitesh lives in Mumbai, INDIA and works with Nexvisioinix, one of the leaders in providing solutions based on Microsoft BI technologies. (For more information on Nexvisionix visit www.nexvisionix.com)
 
Since year 2003, he has been working on Microsft .NET and BI technologies such as Microsoft Analysis Services 2005. He is also proficient in MDX.

Permalink | Advertise | Privacy | Mobile
Web02 | 2.6.130516.1 | Last Updated 19 Aug 2008
Article Copyright 2008 by khatri.hitesh
Everything else Copyright © CodeProject, 1999-2013
Terms of Use
Layout: fixed | fluid