dcsimg


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Save picture

  1. #1
    joyce Guest

    Save picture


    does anyone know what is the SQL command used to save and retrieve a OLE object
    into Access database? (i'm using pictureBox to store the picture.

    thanks for help!


  2. #2
    Larry Rebich Guest

    Re: Save picture

    Joyce:

    If you are using DAO then the following tip may be useful:

    Some months ago I wrote a tip of the month that I call 'Store then Retrieve
    a File from a Jet Database Field'. Link to http://www.buygold.net/tips then
    look for the October 2000 tip of the month. A sample program is provided.
    From the tip's intro:

    I recently had a requirement to store a picture in a Jet [Access] database.
    I had never done this before so I posted a question in a couple of the news
    groups. I got suggestions on how to store the picture but I didn't get any
    real code - so I wrote some VB code to test the suggestions. I generalized
    the code, encapsulated it in a DLL, and decided to make it the October
    tip-of-the-month.



    Cheers,
    Larry Rebich

    More tips link to:
    http://www.buygold.net/tips

    Please:
    No personal e-mail questions :-)


    "joyce" <joycesim@yahoo.com> wrote in message news:3c84becf$1@10.1.10.29...
    >
    > does anyone know what is the SQL command used to save and retrieve a OLE

    object
    > into Access database? (i'm using pictureBox to store the picture.
    >
    > thanks for help!
    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center