sql Image datatype in xsl/xml

Question

User-1624837841 posted

Hi

I am using SQL Server 2005 and my table, column, datatype is "Image". I have no image path , image in bytes format. How can I show image through xsl/xml ? becouse I using XML for my frontend view.

Please help

Answer 1

User-890328799 posted

You'll probably need some HTTP handler to display the images from the DB based on some ID, e.g. ShowImage.ashx?ImageID=1. There are a lot of guides around, e.g.:

http://wiki.asp.net/page.aspx/687/http-handlers-to-handle-images/

To integrate this with some XML / XSLT front end, you can use HTML to display the images using the <img> tag.

Answer 2

User1288087783 posted

I have image datatype and I am having also image handler to render images but how you create XML and generate image from XSLT to HTML.