Storing large size JPEG images in SQL Database

Posted by Sankar20092010 under VB.NET on 1/13/2014 | Points: 10 | Views : 745 | Status : [Member] | Replies : 1
Hi..
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

Sankar




Responses

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

Up
0
Down
Hi Sankar,

Yes, you can do it.

This article http://www.dotnetfunda.com/articles/show/63/dynamically-generating-thumbnail-images-in-aspnet-with-csharp-without 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://www.dotnetfunda.com/codes/show/984/creating-high-quality-thumbnail-image-in-csharp, this may also help.

Thanks

Regards,
Sheo Narayan
http://www.dotnetfunda.com

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

Login to post response