Solved

Vb.net 2008 how to save pic to mysql

Posted on 2009-04-08
5
707 Views
Last Modified: 2013-11-26
i use vb.net 2008 how to save picture file to mysql server.
pls provide code. and what data type should i use on the mysql server.
0
Comment
Question by:aarontham
  • 2
  • 2
5 Comments
 
LVL 9

Expert Comment

by:Sreedhar Vengala
ID: 24104155
0
 
LVL 9

Accepted Solution

by:
Sreedhar Vengala earned 250 total points
ID: 24104170
0
 
LVL 3

Assisted Solution

by:AxleWack
AxleWack earned 250 total points
ID: 24352478
Hi,

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

0
 

Author Comment

by:aarontham
ID: 24352501
hi AxleWack,

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

Expert Comment

by:AxleWack
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.

0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

In my previous two articles we discussed Binary Serialization (http://www.experts-exchange.com/A_4362.html) and XML Serialization (http://www.experts-exchange.com/A_4425.html). In this article we will try to know more about SOAP (Simple Object Acces…
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…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

823 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