Hi,

I was wondering if I could get some input on uploading and displaying multiple images for products. I've only always done just one image per product using the database ID for the name of the image when uploading the image, [ID].jpg, etc. And then its pretty easy to display the image, as long as you only have one image. I want to do something like the way its done on craigslist.com. You can Browse to at least four images and then upload them all at once. The uploading is not the problem. I got that covered. The problem is how do I organize them and then display them. I don't want a gallery or anything fancy like that.

I was actually thinking of creating a folder for all of the product IDs and then dumping multiple images to the folder, naming them a.jpg, b.jpg, etc., then read the entire folder when the image is selected, maybe just redraw the images as thumbnails first.

I may be over thinking this thing.

Any suggestions would be greatly appreciated.

Thanks,
Richard

IMHO, I would store the images in a database, of course that is just me.

In so far as relating images to products and such, I would create a table in your database that stores the path to the image and the id that that image relates back to. (I think this will save you a lot more headaches then setting up an elaborate naming convention)

so when a user would navigate to X product, you could pass in the id through a stored procedure something like

SELECT imagePath from <table> where productID = @id

then in code you could add images dynamically to the page:

foreach(DataRow dr in dt.Rows)
{
Image img = new Image();
img.ImageUrl = Convert.ToString(dr["path"]);
//add img control to a container control
}

Or something similar to that.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html

Discussion:
http://p2p.wrox.com/topic.asp?TOPIC_ID=56429

Thanks d. That was actually one of the options I was considering. That way it would also allow me to set status and priority on the images too, set one of the images as the primary so that I can display just one main image when needed on other pages.

Very much appreciate the response. Thanks for the feedback.

Richard

No problem ^^

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html

Discussion:
http://p2p.wrox.com/topic.asp?TOPIC_ID=56429