How to Save Images in MySQL Database Using C#

Deepak Sharma

C#Database MySQL Windows Forms Applicationsave images in MySQL

7 Comments

Join the conversation! Your thoughts help the community grow.

Dmitrii Nefedov3y ago
How to show the same image?
thiyagaraj7y ago
I got this error "Column @Image Cannot be null" string FileName = textBox1.Text; byte[] ImageData; fs = new FileStream(FileName, FileMode.Open, FileAccess.Read); br = new BinaryReader(fs); ImageData = br.ReadBytes((int)fs.Length); br.Close(); fs.Close(); con.Open(); cmd.Connection = con; cmd.CommandText = "insert into test(Image) values(@Image)"; cmd.Parameters.Add("@Image", MySqlDbType.Blob); cmd.Parameters["@Image"].Value = ImageData; textBox1.Text = ImageData.ToString(); int result = cmd.ExecuteNonQuery(); if (result > 0) { MessageBox.Show("Blood Doner Saved Successfully", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Blood Doner not Saved Successfully", "Not Saved", MessageBoxButtons.OK, MessageBoxIcon.Warning); }
Chandrakant Patil8y ago
This is very short and good article for save image into mysql.
Mukhtiyar Ali9y ago
How pass multiple images
carlos salgado11y ago
May I set something on mysql to store long images files? because I'm trying but give me an error and I'm using the same code, the images is less than 16 MB and I'm using LONGBLOB. Thanks
Michel Challita11y ago
This is giving me 'input string was not in a correct format'
Anurag Sarkar13y ago
NiceOne:)

In this article I will explain how to save images into a MySQL database in Windows Forms applications using C#.

Introduction

In this article first we will create a table in a MySQL database and then we will use a Windows Forms application to save an image into the database.

Description

Create a table in a MySQL database using MySQL browser as in the following. To store the image:

For storing images you can use any of the BLOB (Binary Large Object) data types based on your storage requirements. We are using the MEDIUMBLOB data type. The following are the storage capacities of various BLOB types in MySQL:

Data Type	Storage Capacity
BLOB	255 bytes
TINYBLOB	65,535 bytes (64 KB approx.)
MEDIUMBLOB	16,777,215 bytes (16 MB approx.)
LONGBLOB	4,294,967,295 bytes (4 GB approx.)

Create a new Windows Forms application and arrange controls on the form as in the following:

Add a reference to the MySql.Data dll using the Add Reference dialog box and include the following two namespaces:

using MySql.Data.MySqlClient;
using System.IO;

Write the following code in the Click event of PictureBox to select an image to save in the database:

private void pbStudentImage_Click(object sender, EventArgs e)
{
try
{
OpenFileDialog openFileDialog1 = new OpenFileDialog();
openFileDialog1.Filter = "Image files | *.jpg";
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
txtStudentImage.Text = openFileDialog1.FileName;
pbStudentImage.Image = Image.FromFile(openFileDialog1.FileName);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}

Assign the same event to the Click and Enter events of the "txtStudentImage" TextBox , as in:

this.txtStudentImage.Click += new System.EventHandler(this.pbStudentImage_Click);
this.txtStudentImage.Enter += new System.EventHandler(this.pbStudentImage_Click);

Write the following code in the Click event of the btnSave Button:

private void btnSaveImage_Click(object sender, EventArgs e)
{
MySqlConnection con = new MySqlConnection(ConString);
MySqlCommand cmd;
FileStream fs;
BinaryReader br;
try
{
if (txtFirstName.Text.Length > 0 && txtStudentImage.Text.Length > 0)
{
string FileName = txtStudentImage.Text;
byte[] ImageData;
fs = new FileStream(FileName, FileMode.Open, FileAccess.Read);
br = new BinaryReader(fs);
ImageData = br.ReadBytes((int)fs.Length);
br.Close();
fs.Close();
string CmdString = "INSERT INTO Students(FirstName, LastName, Image, Address) VALUES(@FirstName, @LastName, @Image, @Address)";
cmd = new MySqlCommand(CmdString, con);
cmd.Parameters.Add("@FirstName", MySqlDbType.VarChar, 45);
cmd.Parameters.Add("@LastName", MySqlDbType.VarChar, 45);
cmd.Parameters.Add("@Image", MySqlDbType.Blob);
cmd.Parameters.Add("@Address", MySqlDbType.VarChar, 100);
cmd.Parameters["@FirstName"].Value = txtFirstName.Text;
cmd.Parameters["@LastName"].Value = txtLastName.Text;
cmd.Parameters["@Image"].Value = ImageData;
cmd.Parameters["@Address"].Value = txtAddress.Text;
con.Open();
int RowsAffected = cmd.ExecuteNonQuery();
if (RowsAffected > 0)
{
MessageBox.Show("Image saved sucessfully!");
}
con.Close();
}
else
{
MessageBox.Show("Incomplete data!", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}