Skip to content

Personal tools
You are here: Home » SQL Server » SQL Server Articles Archive » Implementing Office Web Component Pivot Tables with ASP.NET » DataSource for Pivot Table using C#
Seeking new owner for this high-traffic site.
Tap into the potential of this DBA community to expand your business! Interested? Contact us today.
Who Are You?
I am a:
Mainframe True Believer
Distributed Fast-tracker

[ Results | Polls ]
Votes : 3559


Above in this comment thread: Implementing Office Web Component Pivot Tables with ASP.NET » DataSource for Pivot Table using C#

DataSource for Pivot Table using C#

Posted by mougue at 2005-11-21 05:41 PM
Hopefully this article will help you. If you look above on this page, you should see the section and code snipped where we manually set the data source of the pivot table via VBScript. I think this answers your question, unless there are additional details you need.

DataConnection On Server Side

Posted by lpeens at 2005-11-22 01:17 AM
Hi There,

Thanks for your prompt reply. I actually thought that I was going to wait for a couple of days. I heard today that I need to make the connection on the server side, cause of the way we are set up here. We are using ConTEXT to program in, which is very new to me. So i need to figure out how to set the connection in the aspx.cs file. Can you help me?

Thank you for your reply




Posted by dslaby at 2006-01-09 01:15 AM
I came across your posting because I'm working with the same issue. Please post or send you code or article to me. Thanks.

Please send me the code....

Posted by dgupta at 2007-02-21 02:18 AM
I am not able to see the code & section...

Could you please send me the section & code, from where I can give the datasouce of my cube through VBScript...I really need it ASAP...

My Email id is

Transaction Management
Reduce downtime and increase repeat sales by improving end-user experience.
Free White Paper
Database Recovery
Feeling the increased demands on data protection and storage requirements?
Download Free Report!

Powered by Plone