Author: sbudlong | Posted on: 8/28/2009 3:54:58 PM | Views : 243

In my googling, I came across this forum http://forums.asp.net/p/471687/471745.aspx#471745
Q: "I was wondering if there was a way to upload multiple image files to ONE database record."
A: What are you looking to accomplish? If you have multiple images in a single record, you will need to have multiple fields. This is generally a bad idea. I would just add multiple records, and then create some other database technique to join them. Perhaps:

PictureGroup
---------------
PictureGroupID
PictureGroupName
-- Whatever else...


Picture
--------
PictureID
PictureGroupID
Picture

This way, if you have multiple related pictures, you can create multiple picture records that point to the single PictureGroup record.


How do I accomplish this with a form? I want to collect the visitor's email (the identifier for the images the visitor uploads), a text story in a textbox, and ...

Go to the complete details ...