MySql - Insert image in to an existing table record

Question

Hi I have table which contains the fields org_nameorg_addresscitycountryphonelogo.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?

Iftikar Hussain · Answer

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

Kavi suja · Answer

Hi I correct this task by referring the following link: http://stackoverflow.com/questions/8439202/upload-image-directly-through-mysql-command-line

Kavi suja · Answer

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; Butthe image can't save in DB.Can you give me any ideas?

Iftikar Hussain · Answer

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.