We help IT Professionals succeed at work.

Inserting images into SQL7 using VB6

ExtremeFitness
on
Medium Priority
271 Views
Last Modified: 2008-02-01
I am trying to insert (and retrive) image into SQL Server 7.

I have found some examples of how to do this, however it seems I need aTypeLib that I cannot find....  typelib with the IStream and IPersistStream Interfaces
Any idea where I can dload this??

Or an alternate method for insertng my images with Sample code?

Thanks....
Comment
Watch Question

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Perfect!!!!

Now do you know if there is a way I can insert the pic from the DB directly to an Imgbox or picbox etc???

Commented:
Yes. After opening the recordset set the PictureBox's Datasource and DataField:

Set Picture1.Datasource = rs
Picture1.DataField = "YourFieldName"

Author

Commented:
Thanks.....
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.