locked
sql Image datatype in xsl/xml RRS feed

  • 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

    Thursday, December 31, 2009 3:21 AM

Answers

  • 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.



    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, December 31, 2009 4:18 AM

All replies

  • 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.



    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, December 31, 2009 4:18 AM
  • 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.

    Wednesday, April 24, 2013 2:11 AM