Programming Forums > Web Development and Design > ASP

raikkonen · Oct 27th, 2005, 2:04 AM

How do i display images from my database using asp? The rest of my records are able to be displayed,but the images are not coming out.
what should the datatype for my image field be? At present i have set it at varchar,and entered the value for my image field as "images/cake.jpg"
is there anything wrong with this? i just need to extract out and display my images the same way i display others,without having to pass through the ID or something. is that possible? i've seen some websites and they used Response.binarywrite.

java_roshan · Jan 30th, 2006, 9:19 AM

What u need to do is possibly change the datatype to a binary one and use some code (probably from the internet) to read the image as a binary format and use Response.binarywrite to write it to your database.

Similarly, while retrieve u may use Request.binaryread and some other code to display the image as it should be!

mycplus · Apr 14th, 2006, 1:03 PM

There are two ways to show an image from the data base.

Quote:

At present i have set it at varchar,and entered the value for my image field as "images/cake.jpg"

then you have to upload the image to the images folder. and you will show it like
<img src="<%=objRs("ImageFieldName")%>">

The other way is the binary write. For that you have to use field type like blob, image depending on the database you are using. I think its a bit slower task so you better use the first type.

Thanks

Oct 27th, 2005, 2:04 AM	#1
raikkonen Newbie Join Date: Jun 2005 Posts: 29 Rep Power: 0	Displaying images from database How do i display images from my database using asp? The rest of my records are able to be displayed,but the images are not coming out. what should the datatype for my image field be? At present i have set it at varchar,and entered the value for my image field as "images/cake.jpg" is there anything wrong with this? i just need to extract out and display my images the same way i display others,without having to pass through the ID or something. is that possible? i've seen some websites and they used Response.binarywrite.

Jan 30th, 2006, 9:19 AM	#2
java_roshan Professional Programmer Join Date: Mar 2005 Location: Student of University of Mumbai, Maharashtra State, India Posts: 344 Rep Power: 4	What u need to do is possibly change the datatype to a binary one and use some code (probably from the internet) to read the image as a binary format and use Response.binarywrite to write it to your database. Similarly, while retrieve u may use Request.binaryread and some other code to display the image as it should be! __________________ Visit: http://www.somaiya.edu

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Programming Forums > Web Development and Design > ASP

Displaying images from database