Solved

ASP.NET using Pivot table (OWC 9 W2K)

Posted on 2003-11-18
9
763 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Is Your DevOps Pipeline Leaking?

Is your CI/CD pipeline a hodge-podge of randomly connected tools? You’ve likely got a tool to fix one problem & then a different tool to fix another, resulting in a cluster of tools with overlapping functionality. Learn how to optimize your pipeline with Gartner's recommendations

 
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
 

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Recently while returning home from work my wife (another .NET developer) was murmuring something. On further poking she said that she has been assigned a task where she has to serialize and deserialize objects and she is afraid of serialization. Wha…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

734 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