Retrieving images from SQL Server

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Leeb65 Members Profile Find Members Posts Groupie Joined: 05 December 2003 Location: Germany Status: Offline Points: 62	Post Options Post Reply Quote Leeb65 Report Post Thanks(0) Quote Reply Topic: Retrieving images from SQL Server Posted: 24 October 2005 at 10:26am
	Hi all, I am trying to display images that are stored in SQL Server 2000 in an image datatype field. I need to display the images on a web form. Does anyone know how? Thanks
	Lee

michael Members Profile Find Members Posts Senior Member Joined: 08 April 2002 Location: United States Status: Offline Points: 4670	Post Options Post Reply Quote michael Report Post Thanks(0) Quote Reply Posted: 24 October 2005 at 5:27pm
	It depends how the image was stored, you can convert the stream to a Byte Array then convert the Byte Array to an image doing a Response.BinaryWrite to a seperate aspx page (The Browser should automatically recognize the MIME Type.) So esentially you'd set the image to be something like <img src="myimagepage.aspx?image=someID">
	Blog \| MPG Tracker

michael Members Profile Find Members Posts Senior Member Joined: 08 April 2002 Location: United States Status: Offline Points: 4670	Post Options Post Reply Quote michael Report Post Thanks(0) Quote Reply Posted: 24 October 2005 at 5:32pm
	One easy to understand Code example is here
	Blog \| MPG Tracker

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.