Solved

Vb.net 2008 how to save pic to mysql

Posted on 2009-04-08
5
708 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

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

820 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