Re: Show an image on a web form from MSSQL database

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: William Ryan eMVP (bill_at_NoSp4m.devbuzz.com)
Date: 02/11/04 

Date: Tue, 10 Feb 2004 21:13:48 -0500

There are many examples out there on google if you search for BLOB and
ADO.NET. However, I've had to do this on a few occassions, pre ado.net and
with ADO.NET and as a rule, I think storing images, or sound files or many
other large blob files in the DB is not worth the hassle. Storing a path
reference is quite easy and you'll probably see much better access time and
overall server performance. The only real downside is that you need to be
much more careful about permissions to those files if you are opening it up
via the web, but these days security should be taken very seriously
regardless of the environmnet you are dealing with.

HTH,

Bill
"Dmitri Shvetsov" <dshvetsov@cox.net> wrote in message
news:mteWb.39285$P17.3219@fed1read03...
> Hi,
>
> What's the easiest method to do that? I need to extract an image from
Image
> type column and then display it. Should I store the image as an image file
> on a disk and then assign the image URL to this file? Or there is a easier
> way to do that? Does somebody have a source code for that?
>
> Thanks,
> Dmitri
>
>

Relevant Pages

  • Re: using BLOB objects and ...
    ... you can insert any kind of file to database by using following code ... Example on storing images into BLOB data type. ... CLOB (Character LOB) ...
    (comp.lang.java.programmer)
  • BLOB
    ... I am looking into storing images into SQL and want to use BLOB which I ... John ...
    (microsoft.public.sqlserver.mseq)