Displaying images

Hi,

I am a new VWD user and have been trying to set up a website that allows 1 user to upload images into to SQL Express database and then display them with a variety of other fields.

I have searched the forums, several books and many ASP "training" websites to find out how to do this. Every website seems to teach how to display a list of employees or show photo gallery, but none explains how to upload an image, save it in the appropriate field(s) in the database, and then display it when requested in a Datagrid or Details View using VWD and SQL Express 2005

Can any one give me directions to a solution, or send me a simple solution to this?

The best example of what I need is is a real estate listing, wherethe property for sale has 8 to 10 descriptive fields and 1 to 3 images that are displayed.

Any help would be appreciated.

Spacecaetrg.

I've not seen a response to the above reported request for help.

My problem is exactly the same and I would appreciate any help that can be provided.

Thanks

pmurphy5263

|||

What about this? add an image into a database:

http://alpascual.com/blog/al/archive/2006/11/11/Code-Snip-_2200_Add-images-into-a-database_2200_.aspx

|||

Thanks Al for such a quick response.

I am using VWD and SQL 2005 Express. In defining my SQL table I set up one column as an image. What I don't understand (and I assume I am missing something really simple here) is how I move data into that column (field).

After defining the table I tried adding to the image column.(while still in VWD using "Database Exlporer" and "Show Data Table)..........that is where I am stuck.

What is the expected as an entry to this column?

Whenever I try to insert anything into that column I receive the following message.

Invalid value for cell.....

"The changed value in this record is not recognized as valid.

.Net Framework Data type byte[]

Error Message: You cannot use the Result pane to set this field data to values other than Null."

I am a newbie. Guess I don't have to tell you that.

Any more help will be appreciated.

Thanks

|||

Hi

Make sure the column type is " image " and Here you can find a full sample:Save and Display Image with Sql Server.

If you still have problem ,Could you pls post your table structure and some code ?thanks.