Hello Chrysan,
There are two ways to creat a pivot table control in your page.
(1) Client side control using OBJECT tag
<OBJECT ID="PTable" CLASSID="CLSID:0002E552-0000-0000-C000-000000000046"
WIDTH="100%" HEIGHT="60%"><PARAM name="AutoFit" value="False"></PARAM>
</OBJECT>
(2) Server side control by addiong the reference to the "Microsoft Office
Web Components..." from the Add Reference->COM tab
Add the following line,
using OWC11 = Microsoft.Office.Interop.Owc11;
in the include section of the codebehind where you want to use these
components.
I hope this information helps!
Regards,
Uday Takbhate [MSFT]
Microsoft Developer Support
--------------------
[quoted text, click to view] >Thread-Topic: How to reference PivotTable control in asp.net(vb.net)
code-behind
>thread-index: AcW45NTwsdzD59ppSk+R61iC6xlY0A==
>X-WBNR-Posting-Host: 60.49.16.165
>From: "=?Utf-8?B?Q2hyeXNhbg==?=" <Chrysan@discussions.microsoft.com>
>Subject: How to reference PivotTable control in asp.net(vb.net) code-behind
>Date: Tue, 13 Sep 2005 21:29:01 -0700
>Lines: 7
>Message-ID: <6C1A78E7-8C2F-4DED-B1DC-4F144A49D04F@microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.dotnet.framework.interop
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.dotnet.framework.interop:9594
>X-Tomcat-NG: microsoft.public.dotnet.framework.interop
>
>I have create an asp.net(.aspx) page, with a PivotTable control. I
noticed
>that, I can't reference it in my code-behind(.aspx.vb), because it doesn't
>has the line 'Protected WithEvents PivotTable1 As OWC10.PivotTable' as
>creating other controls, liked Label, Button, ...
>
>Can anybody teach me how to reference the PivotTable control in asp.net
>code-behind? Thanks.
>