System.Drawing/GDI+

Re: automatically resize images before storing in SQL database

RMcBride — Sun, 21 Jun 2009 05:47:36 GMT

Got it. I can see the solution. I just have to figure out how to implement it in my situation. Thanks

Richard

Re: automatically resize images before storing in SQL database

whighfield — Sun, 21 Jun 2009 04:41:49 GMT

The image in the atricle is resized before it is saved to the folder so instead of saving to the folder you would save the image byte array to the database.

http://www.thefrozencoder.ca/post.aspx?id=35c6dbaf-a289-4ce5-822b-1e6e45cb68d7 this article shows you how to do that as well.

Re: automatically resize images before storing in SQL database

RMcBride — Sun, 21 Jun 2009 04:16:12 GMT

Hi whigfield

Alas I am storing the images in a SQL database and your article says "Images must be stored in a folder called “Images”. On the other hand, I could create a serverside version of the file, resize the file and then try to figure out how to get the serverside resized file into the database.

I would appreciate more ideas if anyone has any.

Thanks

Richard

Re: automatically resize images before storing in SQL database

whighfield — Sun, 21 Jun 2009 03:57:03 GMT

http://www.thefrozencoder.ca/post.aspx?id=31972bad-f517-4516-a820-06b9c59196f5 some code I got off the internet that does this

automatically resize images before storing in SQL database

RMcBride — Sun, 21 Jun 2009 02:14:46 GMT

Hi all

I have a page where users can upload photos associated with their records in our database. The photos are stored in a SQL database as an image. Some of these photos are larger than they need to be for display on a web page. Is there a way in ASP to automatically resize these images before they are uploaded in the database?

Thanks

Richard