Displaying image from database

Question

Hi guys,

I am able to display records from a database in a webpart. My question how do I display image in the table also.

Thanks

Answer 1

This "technically" isnt a SharePoint question unless the image is being stored in a list which I assume it isnt :)

This post may help you : http://aspalliance.com/articleviewer.aspx?aid=140 as it relates to returning an image stored in a SQL server database with the use of SQL or a stored procedure. There are related posts on this link also that also describe retrieving binary data from SQL and returning it as image for your web page to display.

Stu

---

Starznet SharePoint Blog : http://www.starznet.co.uk/sharepoint/blog
Please mark replies as answered if you find it has helped you
Contact : http://www.starznet.co.uk/contactstarznet.htm

Answer 2

Well, I still a little lost about logic mainly I have to somehow the a binary conversion and also use the Response object.

Still lost.

Answer 3

Hi,

Well if you are lloking forwad to display this in a wepart yest this is possible.. I have done this, Just do a look you from DB to this list item with a primary key & display the image in the webpart.

if its only list them u can have a colunm which can do this for you..

If you can explaing the req in a better way will become easy to hit with the perfect solution.

Regards
Manu Kaura

Answer 4

Hi Manu kaura,

The requirement is just for me to display a set of images with description from an sql server 2005 database.
Hope it is more clearer now