Images Stored in SQL to show on ASPX pages?

[Vonnie]

I have images stored in SQL (not paths or urls)
I need to show them on webpages but the image control only seems to have a
imageurl property.

Is there another control I should use to databind?

is there a way to databind the imageurl property?

I am using VS 2005 but if you know how to do it in 2003 that helps too.

Thanks mucho for any advice

[Curt_C [MVP]]

you should be able to just .write it to the screen, you wont use an image
control.

Just google it, I think you will find a ton of samples. As a side note, it's
still not a great idea to store the image in the DB if you can do it
elseways... but that's another issue.

--
Curt Christianson
site: http://www.darkfalz.com
blog: http://blog.darkfalz.com

"Vonnie" wrote:

I have images stored in SQL (not paths or urls)
I need to show them on webpages but the image control only seems to have a
imageurl property.

Is there another control I should use to databind?

is there a way to databind the imageurl property?

I am using VS 2005 but if you know how to do it in 2003 that helps too.

Thanks mucho for any advice

[Vonnie]

I found this at sqlteam.com is something like this what you mean?

Response.Write "<a href=" & trim(bobjRS("LinkToURL")) & ">"
Response.Write "<IMG SRC=" & trim(bobjRS("ImageURL")) & " BORDER=0 "
Response.Write " WIDTH=" & trim(bobjRS("Width"))
Response.Write " HEIGHT=" & trim(bobjRS("Height"))
Response.Write " ALT=" & Chr(34) & trim(bobjRS("ALTText")) & Chr(34)
Response.Write "></a>"
Thanks for pointing me in this direction! I googled at lot but never found
anything except storing urlsCurt_C [MVP]" <software_at_darkfalz.com> wrote
in message news:7F**********************************@microsof t.com...> you
should be able to just .write it to the screen, you wont use an image

control.

[Peter Rilling]

Dynamic images have to be rendered from an external file which is what the
href attribute would point to.

Take a look at this article --
http://www.codeproject.com/aspnet/Dy..._Extention.asp.

"Vonnie" <v.******@verizon.net> wrote in message
news:V%DVe.3056$YI6.2476@trnddc05...

I have images stored in SQL (not paths or urls)
I need to show them on webpages but the image control only seems to have a
imageurl property.

Is there another control I should use to databind?

is there a way to databind the imageurl property?

I am using VS 2005 but if you know how to do it in 2003 that helps too.

Thanks mucho for any advice

[Steve C. Orr [MVP, MCSD]]

You'll need a special page (or an HTTP Module that simulates a page) so the
Image control can reference it.

These articles contain most (if not all) of the details you'll need.
http://SteveOrr.net/articles/EasyUploads.aspx
http://SteveOrr.net/articles/ImproveYourImages.aspx

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"Vonnie" <v.******@verizon.net> wrote in message
news:V%DVe.3056$YI6.2476@trnddc05...

I have images stored in SQL (not paths or urls)
I need to show them on webpages but the image control only seems to have a
imageurl property.

Is there another control I should use to databind?

is there a way to databind the imageurl property?

I am using VS 2005 but if you know how to do it in 2003 that helps too.

Thanks mucho for any advice