Solved 2008 how to save pic to mysql

Posted on 2009-04-08
Last Modified: 2013-11-26
i use 2008 how to save picture file to mysql server.
pls provide code. and what data type should i use on the mysql server.
Question by:aarontham
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2

Expert Comment

by:Sreedhar Vengala
ID: 24104155

Accepted Solution

Sreedhar Vengala earned 250 total points
ID: 24104170

Assisted Solution

AxleWack earned 250 total points
ID: 24352478

In your MrSQL DB, try saving the PATH where the images are being saved to. If all your pictures are being saved to your local pc : C:\Pictures, then save the path in the db. Example : If you have 2 column names :
 Car Types | Picture
  Ferarri      |  C:\Pictures\Ferarri.jpg
  Porsche   |  C:\Pictures\Porsche.jpg
  Bmw        |  C:\Pictures\Bmw.jpg

Just save he Path where the image is, under the Picture column in your DB. If you are saving the images to a server then your path would change to something like this : \\Servername\Pictures\Ferarri.jpg and so on.

Hope this helps in any way


Author Comment

ID: 24352501
hi AxleWack,

can i know the pro and con save pic direct to Mysql compare with your solution

Expert Comment

ID: 24352589
Well the way I see it, is by saving the Path(which will be a text value) apposed to  saving an actual image, would be the speed to which your data will be loaded.

In your application you can use 1 picturebox/Image control, to load your images. All that needs to happen is, the picturebox/image control has to read the Path, and then display the image.


Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question