• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 155
  • Last Modified:

image box

how to load an image in records to an imagebox on the form. I have given as imgphoto.picture=adoQset.Fields("images") where images is the column name
0
rmvprasad
Asked:
rmvprasad
  • 3
1 Solution
 
DhaestCommented:
0
 
DhaestCommented:
first, consider that loading images (and files in general) into a database is probably bad regarding the performance. If at all, you should store them in a separate database...

Besides that, you need to read about the .AppendChunk and .GetChunk to write/read to IMAGE (and TEXT) fields in SQL Server.
Another way to do this is store the file location in the database and simply place image files on the hard drive.  As far as removing the file just remove the record holding the location and then use the kill statement to delete the file off the hard drive.
0
 
DhaestCommented:
My recommandation: answered by dhaest
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now