Frustrated over images
Posted on 2010-11-15
I have been attempting to save/retrieve images from an sql server 2005 database off and on for 6 months. I really need help with this.
I have tried numerous examples on the net and have not yet been successfull. I am using Linq to sql to save/retrieve data.
I have a table that stores a before and after picture for each service completed (Services Table).
I also have a table that has a primaryid, foreignkey, foreign key, two image fields (Before and After), and a description text field (Portfolio table).
Users have an option to add photos taken during a service to the portfolio table. The portfolio is visible to the public whereas the service table is only visible to the user. Users also have the option to add pictures from another souce to the portfolio.
I am having a problem trying to figure out how to make the save and retrieve work when I need to save multiple images.
I have a mangled bunch of code from all my attempts and now am completely lost.
So basically what I am asking, begging, is for a solid example of how I would convert the image in order to save and then convert again in order retrieve and display these images. I using Linq to SQL.
If you provide a link, the odds are I have read and tried it.
I am building a website that will have a photo album consisting of before/after pictures.
I also have