Solved

Vb.net 2008 how to save pic to mysql

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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

This article describes relatively difficult and non-obvious issues that are likely to arise when creating COM class in Visual Studio and deploying it by professional MSI-authoring tools. It is assumed that the reader is already familiar with the cla…
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…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

762 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now