Solved

ASP.NET using Pivot table (OWC 9 W2K)

Posted on 2003-11-18
9
757 Views
Last Modified: 2007-12-19
I am trying to use a pivot table (version 9) in an ASP.NET Web application, but I can't connect with the data source.

I am using Visual Studio .NET. If i try with Windows Application it work ok.

Can anybody help me - PLEASE ?

Thanks in advance.
0
Comment
Question by:lausz
  • 5
  • 3
9 Comments
 
LVL 6

Expert Comment

by:zrh
ID: 9820265
Are you getting any particular error? Or just an empty dataset?  Also, where did you get this Pivot Table Control?
ZRH
0
 
LVL 6

Author Comment

by:lausz
ID: 9824360
I am using OWC 9.0.

I can see the control in the page but I never could connect it to a database.
0
 

Accepted Solution

by:
csmith12 earned 300 total points
ID: 9824800
Check your code, you should have saved your pivot table as xml and then saved to web server. You code should load the OWC object from the xml file on the web server. I would bet it works from winform app because it can load the xml file from you local box.

0
 
LVL 6

Author Comment

by:lausz
ID: 9824819
These are the steps that I did-

I drag the pivot table control into my aspx page. Remember I am talking owc version 9, (because the version 10 works ok). But I see all the top controls greyed, for that I cant connect to my database.
0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 

Expert Comment

by:csmith12
ID: 9825326
I have worked with owc 10 before, but not 9.

You last comment makes sence to me i believe. When you drag the object on to the page, the HTML that is created is just an object tag. The control will need to be configured to create or load a speadsheet. This can come from web server or local hard disk, depending on your code. So the controls being greyed out seems to make sence. Is there a sheet loaded in 9 by default?

0
 
LVL 6

Author Comment

by:lausz
ID: 9826094
csmith12 ...

I can give another clue, if I select the windows application instead of web application it works too.

I can increase the points to you ... if you have time, can you try with the version 9, I am sure you have it installed in your machine.. only add the control in your tool box and tell me...if you can, why is imposible to connect the pivot woth the database..
0
 
LVL 6

Author Comment

by:lausz
ID: 9850489
Nothing?
0
 

Expert Comment

by:csmith12
ID: 9851849
Let me try with 9.
0
 
LVL 6

Author Comment

by:lausz
ID: 9851990
OK... i CAN WAIT...

I'LL INCREASE THE POINT FOR YOU IF YOU CAN DETERMINE IF IS POSIBLE TO USE OWC 9.0 WITH VISUAL STUDIO FOR WEB APPLICATIONS.

THANKS IN ADVANCE.
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes relatively difficult and non-obvious issues that are likely to arise when creating COM class in Visual Studio and deploying it by professional MSI-authoring tools. It is assumed that the reader is already familiar with the cla…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now