MySql - Insert image in to an existing table record

Kavi suja

Hi,
I have table which contains the fields "org_name,org_address,city,country,phone,logo".Here logo is the columns which datatype is longblob.Initially I insert the data without logo column.Now i want to insert an image in the field "logo".How I insert image file in existing table record?can u help me guys?

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Iftikar Hussain13y ago
Hi,
You need to first convert the files data to byte array.
var bytes = File.ReadAllBytes(pathToFile)

Regards,
Iftikar
Kavi suja13y ago
Hi,
I correct this task by referring the following link:

http://stackoverflow.com/questions/8439202/upload-image-directly-through-mysql-command-line
Kavi suja13y ago
Hi Iftikar,
Thank you for your reply.But actully I'm asking query for insert image from local system in to MySQL Table.in update query I use this "Update organizationdetails set LOGO= 'C:\Documents and Settings\Administrator\Desktop\Fortis.JPEG' where organization_id = 1;" But,the image can't save in DB.Can you give me any ideas?
Iftikar Hussain13y ago
Hi,
Since you are trying to insert image for existing records, then you need execute update query as shown below

public void SaveImage(byte[] buffer, string org_name)
{
string strcmd = "UPDATE OrgDetails SET logo=?logo WHERE org_name=?org_name)";

MySqlConnection conexion = new MySqlConnection(DSN1);
conexion.Open();

MySqlCommand cmd = new MySqlCommand(strcmd, conexion);
MySqlParameter param = new MySqlParameter("?logo", MySqlDbType.LongBlob);
param.Size = buffer.Length;
param.Value = buffer;

cmd.Parameters.Add(param);
cmd.Parameters.Add(new MySqlParameter("?org_name", org_name));

conexion.Open();

cmd.ExecuteNonQuery();
conexion.Close();
}

Regards,
Iftikar

Remember to click "Mark as Answer" on the post, if it helps you.