sql server 2005 images and asp.net

[JeI-Paradigm]

hey gurus!

How do i load data from an image(datatype) column into a asp.net datagrid. the data is a picture and are in various formats when i inserted them. mostly jpeg and png.

when i use no code, only wizards to populate the grid it loads the data as system.byte[]. what does that mean...do i need to convert or manually load the file.

I'm quite lose
please help

PS. there was another post with this exact issue but there are no replies for 2 months now so i am posting this one again in hopes that someone can help

J!

[Rohit Kukreti]

Basically the technique of storing images in database and then reading from it is called Data BLOBing. Look @ the below links.. they should help

http://support.microsoft.com/default.aspx?scid=kb;en-us;326502
http://www.codeproject.com/aspnet/BLOBRead.asp

[JeI-Paradigm]

thanks but ive been there and tried that and many others and all they do is return the hex data... very helpful for customers who can barely type right

any way im just going to store the files with relative image paths and hope my server has sufficient security to protect them against hackers.

if not...well at least my site will work..


Thanks
J!

[Rohit Kukreti]

Hi,

Can you post the code you are using for reading the BLOB data and displaying it as image?

[JeI-Paradigm]

no i cant because there is no code. i am using a program to do this so it is all encrypted.

program is called dbqwiksite...

sorry
J!