OWC Spreadsheet and persisted ADO recordset

M

MrNDIS

It seems that both charting and pivot table components can read in XML
generated from ADO persisted record set using the following syntax

ChartSpace1.ConnectionString = "Provider=MSPersist.1"
ChartSpace1.CommandText = "URL providing persisted data"


Is it possible to do the same with SpreadSheet component, all my
experiments are failing so far. Any insights? The goal is to read an
persisted recordset and put it in a worksheet.


Thanks
 
A

Alvin Bruney [MVP]

What errors are you having, the worksheet will bind directly to the
recordset because the recordset implements idatasource.
 
M

MrNDIS

What errors are you having, the worksheet will bind directly to the
recordset because the recordset implements idatasource.
Click to expand...

Can you show an example of binding spreadsheet to a recordset and can
it bind to XML persisted recordset?
 
Top