How to store image to MySQL Database using VB.Net

August 29, 2016 | By | Reply More

There are many people, VB and MySQL Master that does not agree with this way to store image into MySQL Server. Apart from that, I just want to make a note for myself how to store image into MySQL Server from VB.Net. The image is saved as Blob field type. This could be Blob, Mediumblob or Longblob. The other way, we can save the file path of the image on a computer and then this file path will be saved to the MySQL table. I will discuss and write about this on the next post. For now, I will show how to store image to MySQL Table from VB.Net.

Before we go through, we need to make a table with a Blob field type. For example, here is my tbl_test design:

table-blob

As you can see, my tbl_test contains two fields. ID and Image_File with LONGBLOB datatype. To store images to MySQL, you must have at least one field with BLOB datatype. The table content when filled with images will looks like this:

save image as blob vb.net

I am using MySQL Workbench to display the table properties above. You may use any program to create or alter your MySQL tables.

Now, its start to switch to Microsoft Visual Studio

Design the interface. On the example below, I have 4 main controls. Picturebox and three buttons.

save image as blob vb.net tutorial

The idea is to browse the image first, and display it on the Picturebox1 and then save the image to MySQL using Save button.

Browse button Code:

The Browse button will get the image file path and then passed to the Picturebox1 to be displayed as image. When this program is running, it will looks like this:

save image to mysql table from vb

Save button code:

Please note that on the code above, you won’t find any MySQL connection string etc., because I have created MySQL Connection module. So this module can be accessed from any form on my project without having to type the MySQL connection code repetitively. Here is my module. I suggest you to create one:

Now all should work perfect. The only problem I have is the file size limitation that can be saved to MySQL. Maximum file that is supported by BLOB datatype can be read on this official explanation on MySQL website.

Tags: , ,

Category: MySQL, Programming, VisualBasic.NET

Leave a Reply