ASP.NET using Pivot table (OWC 9 W2K)

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.
LVL 6
lauszAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

zrhCommented:
Are you getting any particular error? Or just an empty dataset?  Also, where did you get this Pivot Table Control?
ZRH
0
lauszAuthor Commented:
I am using OWC 9.0.

I can see the control in the page but I never could connect it to a database.
0
csmith12Commented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

lauszAuthor Commented:
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
csmith12Commented:
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
lauszAuthor Commented:
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
lauszAuthor Commented:
Nothing?
0
csmith12Commented:
Let me try with 9.
0
lauszAuthor Commented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.