Solved

ASP.NET using Pivot table (OWC 9 W2K)

Posted on 2003-11-18
9
754 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
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 

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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

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…
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

744 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

16 Experts available now in Live!

Get 1:1 Help Now