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 [] bufferstring extension) { string strSql = SELECT * FROM File; DataSet ds = new DataSet(Image); OdbcDataAdapter tempAP = new OdbcDataAdapter(strSqlthis._objConn); OdbcCommandBuilder objCommand = new OdbcCommandBuilder(tempAP); tempAP.Fill(dsTable); 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(dsTable); } 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(strSqlthis._objConn); OdbcCommandBuilder objCommand = new OdbcCommandBuilder(tempAP); tempAP.Fill(dsTable); 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();} }