How to save image in MYSQL using C#

Question

He
llo friends,
I am facing big problem.. i want to save image in mysql using c#... but i do not have any idea how can i save and what is the code... so if you have any idea then give me code or suggetion...

Thanks in Advance

Jaganathan Bantheswaran · Answer

Hi, Here is the code to save and retrieve the image with MySQL. Note: Here the Data field should be of type longblob . public string addImage(byte [] buffer,string extension) { string strSql = "SELECT * FROM File"; DataSet ds = new DataSet("Image"); OdbcDataAdapter tempAP = new OdbcDataAdapter(strSql,this._objConn); OdbcCommandBuilder objCommand = new OdbcCommandBuilder(tempAP); tempAP.Fill(ds,"Table"); try { this._objConn.Open(); DataRow objNewRow = ds.Tables["Table"].NewRow(); objNewRow["Extension"] = extension; objNewRow["Data"] = buffer; ds.Tables["Table"].Rows.Add(objNewRow); // trying to update the table to add the image tempAP.Update(ds,"Table"); } catch(Exception e){return e.Message;} finally{this._objConn.Close();} return null; } // This function to get the image data from the database public byte [] getImage(int imageNumber) { string strSql = "SELECT * FROM File"; DataSet ds = new DataSet("Image"); OdbcDataAdapter tempAP = new OdbcDataAdapter(strSql,this._objConn); OdbcCommandBuilder objCommand = new OdbcCommandBuilder(tempAP); tempAP.Fill(ds,"Table"); try { this._objConn.Open(); byte [] buffer = (byte [])ds.Tables["Table"].Rows[imageNumber]["Data"]; return buffer; } catch{this._objConn.Close();return null;} finally{this._objConn.Close();} }

How to save image in MYSQL using C#

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (1)