get images from SQLServer DB and show on webpage

get images from SQLServer DB and show on webpage

am 11.07.2005 19:44:40 von martin

Hi,

I have images saved in a SQL Server DB on a webserver. How can I get them
and show them on a webpage?

Thanks
Martins

RE: get images from SQLServer DB and show on webpage

am 11.07.2005 20:02:03 von JitGanguly

http://www.4guysfromrolla.com/webtech/060100-1.shtml
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?ln gWId=4&txtCodeId=6108
http://www.stardeveloper.com/articles/033101-1.shtml
http://www.stardeveloper.com/articles/040401-1.shtml
http://www.infinitemonkeys.ws/infinitemonkeys/articles/Asp/9 52.asp
http://www.sagas.net/asp/displayone.asp?id=92
http://www.sagas.net/asp/displayone.asp?id=93


"Martin" wrote:

> Hi,
>
> I have images saved in a SQL Server DB on a webserver. How can I get them
> and show them on a webpage?
>
> Thanks
> Martins
>
>
>
>

Re: get images from SQLServer DB and show on webpage

am 11.07.2005 21:42:41 von Roland Hall

"JitGanguly" wrote in message
news:300B3723-B16D-4E63-A676-CD2D8D0DCA25@microsoft.com...
: http://www.4guysfromrolla.com/webtech/060100-1.shtml
:
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?ln gWId=4&txtCodeId=6108
: http://www.stardeveloper.com/articles/033101-1.shtml
: http://www.stardeveloper.com/articles/040401-1.shtml
: http://www.infinitemonkeys.ws/infinitemonkeys/articles/Asp/9 52.asp
: http://www.sagas.net/asp/displayone.asp?id=92
: http://www.sagas.net/asp/displayone.asp?id=93

To add... saving the link in the db and saving the images as files on your
server gives better performance, less overhead and keeps your database from
bloating needlessly.

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp

Re: get images from SQLServer DB and show on webpage

am 13.07.2005 00:57:45 von mmcginty

"Roland Hall" wrote in message
news:%234cW0ClhFHA.1948@TK2MSFTNGP12.phx.gbl...
> "JitGanguly" wrote in message
> news:300B3723-B16D-4E63-A676-CD2D8D0DCA25@microsoft.com...
> : http://www.4guysfromrolla.com/webtech/060100-1.shtml
> :
> http://www.planet-source-code.com/vb/scripts/ShowCode.asp?ln gWId=4&txtCodeId=6108
> : http://www.stardeveloper.com/articles/033101-1.shtml
> : http://www.stardeveloper.com/articles/040401-1.shtml
> : http://www.infinitemonkeys.ws/infinitemonkeys/articles/Asp/9 52.asp
> : http://www.sagas.net/asp/displayone.asp?id=92
> : http://www.sagas.net/asp/displayone.asp?id=93
>
> To add... saving the link in the db and saving the images as files on your
> server gives better performance, less overhead and keeps your database
> from
> bloating needlessly.
>
> Roland Hall

To add more... but there are substantial advantages if you must manage a
large number of images, and/or must work around other file system
constraints, like for instance, different images with the same original file
name. Above a certain number of images, and given effective indexes, the
performance difference is negligible. And lastly, it can be extremely
convenient to be able to manage a large number of images in the form of a
few files, as opposed to trying to deal with hundreds of thousands of
separate files.


-Mark





> /* This information is distributed in the hope that it will be useful, but
> without any warranty; without even the implied warranty of merchantability
> or fitness for a particular purpose. */
> Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
> WSH 5.6 Documentation -
> http://msdn.microsoft.com/downloads/list/webdev.asp
> MSDN Library - http://msdn.microsoft.com/library/default.asp
>
>