tags:

views:

67

answers:

1

I am relatively new to sql and asp. My problem is that i need to be able to upload a number of image files, mainly jpgs, to a sql database database. Then i need to be able to display them as part of a catalogue. Ive searched around for a while and am struggling to find anything that seems to let me do this.

Any help or guidance would be greatly appreciated.

+2  A: 

The best way to do this would be to upload the files to a directory on the web server, then just store the path to the file in the SQL database.

You can store the actual image in the DB using BLOB columns, but it's generally not recommended.

Eric Petroelje
Plus one on this. I have attempted storing images in the database in applications in the past, and it causes all sorts of issues, especially once you start adding large amounts of images, because the size of the database grows way too fast.
sunmorgus
Thanks, will go down that route