Display SVG from DB

[pkamil83]

Hello

I've got a table on SQL Server 2005 with columns:

ID int
Text XML
Image varbinary(max)

In this table I'm having SVG images.
All I have to do is to display those images on ASP.NET 2 web site (C#),
but I have no idea how to do that. I would also like to have the XML
text displayed under the Image.

Could You please help me?

 

[Kevin Spencer]

First of all, you will have to convert the image format in order to display
the image in a web page. The most commonly-supported formats are JPEG and
GIF. Second, to display text below the image, you must create a web page
that references the image. A web page does not actually contain any binary
data. It has references to the URL of binary data which is downloaded
separately by the browser and displayed in the web page according to the
markup in the page.

So, you will need to create an ASPX page that converts an SVG image to JPG
or GIF, sets the Response.ContentType to "image/jpg" (etc), and streams the
binary image to the browser. You will also need an ASPX page with an img tag
in it that references the ASPX page that provides the image.

--
HTH,

Kevin Spencer
Microsoft MVP
Bit Player
http://unclechutney.blogspot.com

Where there's a Will, there's a William.