BLOB From MS SQL

Discussion in 'ASP .Net' started by Daren Hawes, Jun 14, 2006.

  1. Daren Hawes

    Daren Hawes Guest

    Hi,

    I have a MS SQL DB containing images as BLOBS. I can view them in a
    browser, but my problem is I need to FTP these images out of the web site.

    Can soemone provide me a coding example that will save a physical image
    (C:\image.jpg) from a BLOB.

    My current system does not actually save an image as we address the image
    src like www.mysite.com/showimage.aspx?ID=1

    Thanks Daren
    Daren Hawes, Jun 14, 2006
    #1
    1. Advertising

  2. If you can output it to browser then i do not see any problem saving it to
    the file.
    Just use FileStream instead of Response object.

    George


    "Daren Hawes" <> wrote in message
    news:%...
    > Hi,
    >
    > I have a MS SQL DB containing images as BLOBS. I can view them in a
    > browser, but my problem is I need to FTP these images out of the web site.
    >
    > Can soemone provide me a coding example that will save a physical image
    > (C:\image.jpg) from a BLOB.
    >
    > My current system does not actually save an image as we address the image
    > src like www.mysite.com/showimage.aspx?ID=1
    >
    > Thanks Daren
    >
    George Ter-Saakov, Jun 15, 2006
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Earl Teigrob
    Replies:
    3
    Views:
    8,963
    Earl Teigrob
    Jan 6, 2004
  2. Gordz
    Replies:
    3
    Views:
    3,923
    John Oakes
    Jun 7, 2004
  3. nkunapa
    Replies:
    4
    Views:
    6,710
    nkunapa
    Aug 10, 2005
  4. Juergen Gerner

    Storing files in a BLOB field via SQL

    Juergen Gerner, Jun 6, 2004, in forum: Python
    Replies:
    7
    Views:
    1,854
    Martin Bless
    Jul 6, 2004
  5. Steve
    Replies:
    4
    Views:
    349
    James Willmore
    Nov 28, 2003
Loading...

Share This Page