Solved

ASP.NET using Pivot table (OWC 9 W2K)

Posted on 2003-11-18
9
762 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
Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

 
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

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server Connection String through a VPN 8 65
VB.NET Textbox input validation 4 64
Get month and date in a format 4 44
Asp.Net Session Question 2 33
This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
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 …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

763 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