Storing large size JPEG images in SQL Database

Posted by Sankar20092010 under VB.NET on 1/13/2014 | Points: 10 | Views : 714 | Status : [Member] | Replies : 1
I am using a windows application program (VB.NET and SQL Server 2005).
I am uploading large JPEG , BMP Photos to a picture box , Currently am saving the file as it is to database by converting to binary. But Large images take time when retreiving from database.

Is there any method to resize the large image and then save the image to database as binary data.

Thanks and Regards



Posted by: Sheonarayan on: 1/13/2014 [Administrator] HonoraryPlatinum | Points: 25

Hi Sankar,

Yes, you can do it.

This article has a method called CreateThumbnail that creates thumbnail of the image and returns array of byte that you can save into the database.

Here is one more code snippet that creates high quality thumbnail image ttp://, this may also help.


Sheo Narayan

Sankar20092010, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response