針對如何用 ADOMD.NET Data Provide綁定 PivotGridControl 到OLAP多維數(shù)據(jù)集，我們給出一個具體代碼事例供大家參考：

• Data Source - a path to a local cube file that will serve as a datasource.
• Initial Catalog - a data catalog that contains cubes.
• Cube Name - the name of the cube that provides OLAP data.

代碼如下：

C#

using System;
using System.Windows.Forms;
using DevExpress.XtraPivotGrid;

namespace XtraPivotGrid_ADOMD {
    public partial class Form1 : Form {
        public Form1() {
            InitializeComponent();
        }
        void Form1_Load(object sender, EventArgs e) {

            // Specifies that PivotGridControl should use the ADOMD.NET data provider
            // to bind to an OLAP cube.
            pivotGridControl1.OLAPDataProvider = OLAPDataProvider.Adomd;

            // Configures a data connection.
            // Specifies a string that encapsulates connection parameters 
            // required to access the desired OLAP cube.
            pivotGridControl1.OLAPConnectionString =
                "Data Source=//demos.devexpress.com/Services/OLAP/msmdpump.dll;" +
                "Initial Catalog=Adventure Works DW Standard Edition;Cube Name=Adventure Works;";
        }
    }
}

VB

Imports Microsoft.VisualBasic
Imports System
Imports System.Windows.Forms
Imports DevExpress.XtraPivotGrid

Namespace XtraPivotGrid_ADOMD
    Partial Public Class Form1
        Inherits Form
        Public Sub New()
            InitializeComponent()
        End Sub
        Private Sub Form1_Load(ByVal sender As Object, ByVal e As EventArgs) Handles MyBase.Load

            ' Specifies that PivotGridControl should use the ADOMD.NET data provider
            ' to bind to an OLAP cube.
            pivotGridControl1.OLAPDataProvider = OLAPDataProvider.Adomd

            ' Configures a data connection.
            ' Specifies a string that encapsulates connection parameters 
            ' required to access the desired OLAP cube.
            pivotGridControl1.OLAPConnectionString = _
                "Data Source=//demos.devexpress.com/Services/OLAP/msmdpump.dll;" & _
                "Initial Catalog=Adventure Works DW Standard Edition;Cube Name=Adventure Works;"
        End Sub
    End Class
End Namespace