Pic Storage : Store Pic Path or Convert as Byte???

[raul15791]

Hi,

I'm trying to save some images into my Database of my application. Can I know which of the method below is better and why?

1. Store only the picture path into the database. Retrieve Picture according to its path.

2. Store the Picture in Database as bytes.

Thanks.

[raul15791]

Hi, I did some searching.... Found some related article. Just for reference for those of you who like to know more about this topic.

http://www.webmasterworld.com/forum88/9091.htm

http://databases.aspfaq.com/database/should-i-store-images-in-the-database-or-the-filesystem.html

http://www.webmaster-talk.com/the-database-forum/63229-save-image-to-db2-as-blob.html

[Jx_Man]

I think a better way is convert as byte..
Some trouble can happen if you missing the path of image or moving some pics.

[raul15791]

This is exactly what's in my mind before reading those articles. There are some pros and cons of doing so... You'll know more after you read those articles... :)

[maczoon]

Try MicroSoft example Named Of
VB.NET - Data Access - Read and Write Images from a Database