For research of a new project I need to know if it's possible to read data from an external database and display it using xslt. Is the following possible?
1. Add a extra connection string in de web.config.
2. Create an xslt extension.
3. Create a method in the xslt extension which returns the data from the external database using subsonic (http://subsonicproject.com/).
4. Call the method in xslt to display the data.
I hope this is possible so the project can be build using Umbraco.
External database
Hello,
For research of a new project I need to know if it's possible to read data from an external database and display it using xslt. Is the following possible?
1. Add a extra connection string in de web.config.
2. Create an xslt extension.
3. Create a method in the xslt extension which returns the data from the external database using subsonic (http://subsonicproject.com/).
4. Call the method in xslt to display the data.
I hope this is possible so the project can be build using Umbraco.
Hi,
Yes that is possible. In fact there is a video up on umbraco.tv that describes this. The first three minutes are free.
Basically what you need to do is quer your data and return that in your XSLT Extension as an XMlNodeIterator.
Hope it helps you,
Richard
Here is a discussion on returning data to XSLT from csharp:
http://forum.umbraco.org/yafpostst7905how-to-send-nodeset-to-xslt-extension-and-back.aspx
You might find something useful there.
Thank you for the information. This is just what I needed!
is working on a reply...