OWC - SpreadSheet with ADO.NET

M

Mitshaell

Hello to all.
As I can store a information in a SpreadSheet with ADO.NET in ASP.NET, I
already have the SQLDataReader and wanted to put it in spreadSheet.

Atte

Michel - Peru
 
A

Alvin Bruney [MVP]

None of the Office Web Components are capable of binding to datastructures
from ADO.NET. The reason for this is that the ADO.NET datastructures such as
the dataset do not implement IDataSource interface. Incidentally, unmanaged
COM components do implement this interface so that it is possible for you to
bind to a recordset for instance. You may want to convert your ADO.NET
structures to unmanaged COM containers in order to bind to a OWC component.
Finally, eggheadcafe.com contains an approach to accomplish this. I also
describe a couple more approaches to bind to the components. You should be
able to find a link on MSDN for Microsofts solution to this problem.

--
Regards,
Alvin Bruney [Microsoft MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ http://www.lulu.com/owc
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to automate update on weekly reports spreadsheet 0
Excel - Wich Function should I use? 1
Cannot edit OWC in design mode 1
Integrating information from Word to Excel (not mail merge) 1
Extracting a cell value 2
Linking data in MS Word into Excel 5
Client-side event handling in OWC 2003 Spreadsheet 3
Need Help with a VBA subroutine 0

Top