MS SQL Server OLAP - How to reference PivotTable control in asp.net code-behind?

Author

How to reference PivotTable control in asp.net code-behind?

Chrysan

2005-09-20, 3:24 am

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.

Darren Gosbell

2005-09-20, 9:23 am

You will need to have added a reference to the COM component for OWC so
that VS.Net will generate the RWC (runtime callable wrapper)

And the aspx page will need the runat="server" tag (added automatically
if you drag the control onto the page.) The 'Protected WithEvents...'
declaration should also be added when the control is dragged onto the
form, but it can also be added manually.

For an example using OWC look at:
http://www.gotdotnet.com/Community/...spx?SampleGuid=
52701dd7-5606-4256-819e-d2ecf26e6cd7

For a general article on using OWC with ASP.NET have a look at:
http://www.codeproject.com/aspnet/owc11article.asp

--
Regards
Darren Gosbell [MCSD]
< dgosbell_at_yahoo_do
t_com>
Blog: http://www.geekswithblogs.net/darrengosbell

In article <8B5E39FD-1885-473B-9BEA- D9E6B1CCD09F@microso
ft.com>,
Chrysan@discussions.microsoft.com says...
> 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.
>
>

Raman Iyer [MS]

2005-09-20, 8:24 pm

[forwarding to more appropriate newsgroups]

"Chrysan" <Chrysan@discussions.microsoft.com> wrote in message
news:3AFAADB2-458C-4ABE-971C- 783079BC8B51@microso
ft.com...
>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.
>

Alvin Bruney - ASP.NET MVP

2005-09-21, 9:24 am

To use the code-behind, you will need to create an instance of the pivot
table in-memory object

PivotTable myTable. This is not the same as the pivot table with the user
interface, it only relates to in-memory usage - suitable for things like
file preparation etc.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

"Raman Iyer [MS]" <ramaniy@online.microsoft.com> wrote in message
news:u8wfnlhvFHA.904@tk2msftngp13.phx.gbl...
> [forwarding to more appropriate newsgroups]
>
> "Chrysan" <Chrysan@discussions.microsoft.com> wrote in message
> news:3AFAADB2-458C-4ABE-971C- 783079BC8B51@microso
ft.com...
noticed[color=darkre
d]
doesn't[color=darkre
d]
>
>

dbahooker@hotmail.com

2005-09-22, 3:23 am

god do you know how much faster i would have been doing asp.net?

i couldn't figure that out for the life of me

Alvin Bruney - ASP.NET MVP

2005-09-22, 1:23 pm

no worries

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

<dbahooker@hotmail.com> wrote in message
news:1127377058.636397.54810@g44g2000cwa.googlegroups.com...
> god do you know how much faster i would have been doing asp.net?
>
> i couldn't figure that out for the life of me
>

Sponsored Links