Hello Everyone:
I am a fresher in OWC programming.My question is how can I connnect
a pivotTable to the datasource.For example,I have read the data into
the dataSet,what shall I do in the next?
I place the PivotTable in the "default.aspx" and it is a HTML
Object,How can I set its datasource in the "default.aspx.vb" or how can
I set its datasource in the same page. Some good person would help me ?
Thank you .
Johnny
Lee

Are there any one can help out?

The pivot table can be connected to an OLAP cube. Search this forum for a
link to find out how to do this.

--

________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Professional VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

<lyj.china@gmail.com> wrote in message
news:1146213159.038740.108000@e56g2000cwe.googlegroups.com...
> Are there any one can help out?
>

But I does not build an OLAP Cube.My data is stored in a table,so I
read it into a dataset.My problem is how can I band the data that is in
the dataset to the PivotTable's datasource?

Thank you Alvin Bruney,I am a person in China.I want to buy your Book
of "The O.W.C. Black Book with .NET".But this book is not selt in
China.My only question is how to band data to pivotTable with ADO.Net?
Or how can I band data with a xml doc or stream object?
Thank you again.

The book is available on Amazon. They do ship to China.

The pivot table connects to cubes by default. You will need to build a cube
from the table and connect the pivot table to the cube. Alternatively, you
can use an in-memory Excel range to suck data out of the database into the
spreadsheet. Then bind the pivot table to the spreadsheet. It's a
round-about way but it will work.

--

________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Professional VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

<lyj.china@gmail.com> wrote in message
news:1146564364.013028.126200@j33g2000cwa.googlegroups.com...
> Thank you Alvin Bruney,I am a person in China.I want to buy your Book
> of "The O.W.C. Black Book with .NET".But this book is not selt in
> China.My only question is how to band data to pivotTable with ADO.Net?
> Or how can I band data with a xml doc or stream object?
> Thank you again.
>

Thank you.I will try it.

Hi Alvin:
What is the schema of a pivotTable in the XML file,and how can I
build an XML file that I can use it for the pivotTable
directorily?Could you give me an exmaple for it?Or how can I bind the
data to pivotTable with ADO.NET? I will buy your book,but my project
can't waiting for a long time.The problem has been the big stong that
blocks my way.Could you help me please?

The pivot table schema is available on the microsoft office web site.
However, an easier way is to download a sample cube file (available all over
the internet) and connect to that cube file. Once you have data, write a
simple function to dump the pivot table data to a file. Open the file in
notepad and the schema along with data should be available to you.

--

________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Professional VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

<lyj.china@gmail.com> wrote in message
news:1146743357.024937.60390@g10g2000cwb.googlegroups.com...
> Hi Alvin:
> What is the schema of a pivotTable in the XML file,and how can I
> build an XML file that I can use it for the pivotTable
> directorily?Could you give me an exmaple for it?Or how can I bind the
> data to pivotTable with ADO.NET? I will buy your book,but my project
> can't waiting for a long time.The problem has been the big stong that
> blocks my way.Could you help me please?
>

you CAN connect to relational data without a problem to OWC

you just don't use a ADO.net connection; you use a OLEDB connection
string right??

Thank you again.

My boss want to build the project with ADO.Net.We have already done it
with ADO and ASP.Now,I will try to build it with ASP.Net and ADO.Net.:(

Here is my code.When I put it in the aspx file.There is something wrong
with it.
<%
Response.Buffer = true

Dim rst
rst = Server.CreateObject("ADODB.Recordset")

Dim sqlStr="select * from someTable"
rst.Open(sqlStr, "dsn=test;uid=xx;pwd=xxxxx", 2, 1)

Dim XMLDom
XMLDom = CreateObject("MSXML.DOMDocument")

rst.Save(XMLDom, 1)
Response.Write(XMLDom.XML)
rst.Close
Response.Flush

%>
<object classid=CLSID:0002E55A-0000-0000-C000-000000000046 hspace="60"
id="PivotTable1" ></object>

<SCRIPT language=VBScript>

Dim rsReport
rsReport = CreateObject("ADODB.Recordset") 'Creat an object in the
client side

Dim oStream
(1)oStream = CreateObject("ADODB.Stream")

oXML = document.body.getElementsByTagName("xml")

(2)sXML=oXML[0].OuterHtml

oStream.Open()

oStream.WriteText sXML
oStream.Position = 0
rsReport.Open oStream

PivotTable1.DataSource = rsReport
</SCRIPT>
I put this in my .aspx file. When I run it.There is something wrong in
the code.One error is at "(1)" and the other is at "(2)".(1) error
said: can not creat the object.(2) said the object can not support the
methord.
What is wrong with it? Help me please.

Alvin:
Could you post your book to me ? I will give you the money of the
book and the post fee in advance.Could you help me out?

I have solve the firt problem.It was made by the IE's setting and I
edit the register and I solve it.

Sorry, I don't have any books. The Black Book is available in most online
stores.

--

________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Professional VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

<lyj.china@gmail.com> wrote in message
news:1146821451.597484.249490@g10g2000cwb.googlegroups.com...
> Alvin:
> Could you post your book to me ? I will give you the money of the
> book and the post fee in advance.Could you help me out?
>

I have solved the problem.