Uploading pictures directly to the DB

digink · March 31st, 2010, 10:49 AM

Hey Imad,

I had a quick question I was hoping you could help me with.

I am setting up another site after reading your book (which is great btw) and I have a management section where I am wanting to input records into the DB, now I have the DB set up and I've put in the functionality like learned in the book to input the data with the detailsviews and what not, but the fields for the 8 images I have for the table won't display (and it makes sense since I will be inputting images here that need to be uploaded).

Could you tell me how I could set this up? This would be something under the management section of the site, more for the admin not the end-user. I will have the page password protected using other methods learned in the book I was just wondering how within adding records to the actual table I could also upload the images at the same time.

Thanks

kiwibrit · March 31st, 2010, 07:38 PM

I'm not clear which part of the book this refers to. And do you mean the database has the locations of the image files, or do you truly mean the actual image files themselves?

Imar · April 1st, 2010, 06:19 AM

Does this help?

http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=395

It's not directly applicable to the sample site,but may give you some ideas on how to do it....

Imar

digink · April 1st, 2010, 10:21 AM

kiwibrit,

basically I just want the in a managment section where a user can add, say in this case resorts, to his DB for display on the front end user page I want them to be able to upload actual images from their PCs to the DB, to the fields I have specified within the SQL Server tables.

Imar,

I will check that out and see if it helps, thanks!

kiwibrit · April 1st, 2010, 06:35 PM

Hmm. I have tended to keep image paths rather than images in database - not that I have done much, and not in asp.net. But I glanced at this article and I think you may find it interesting.