Hello I need to retrieve the longblob of a picture from mysql. So first I insert it in the database with this: MemoryStream ms = new MemoryStream(); // PIC_Image.Image.Save(ms PIC_Image.Image.RawFormat); byte [] img = ms.ToArray(); string q = insert into tb_produits (Image) values(' + img+ ') ; Here is to retrieve the picture : public static Bitmap ByteToImage( byte [] blob) { MemoryStream mStream = new MemoryStream(); byte [] pData = blob; mStream.Write(pData 0 Convert.ToInt32(pData.Length)); Bitmap bm = new Bitmap(mStream false ); mStream.Dispose(); return bm; } MySqlDataAdapter sda = new MySqlDataAdapter( SELECT * FROM tb_produits WHERE Designation=' + Designation + 'and Reference=' + Reference + ' MyConnexion); DataTable dt = new DataTable(); sda.Fill(dt); if (dt.Rows.Count == 1) { byte [] img = ( byte [])dt.Rows[0][ Image ]; PIC_Image.Image = ByteToImage(img); } I tried to retrieve but I got an error: Parameter is not valid in this line Bitmap bm = new Bitmap(mStream false);

Hi Please follow below thread- http://stackoverflow.com/questions/13913353/convert-binary-to-bitmap-using-memory-stream

Answer

How to retrieve LONGBLOB image from mysql in picturebox

Jim Tat

326

Hello, I need to retrieve the longblob of a picture from mysql. <div> So first I insert it in the database with this:</div><div> <div class="dp-highlighter"><ol start="1" class="dp-c"><li class="alt">MemoryStream ms = new MemoryStream();  </li><li class="">                  //  PIC_Image.Image.Save(ms, PIC_Image.Image.RawFormat);  </li><li class="alt">                    byte[] img = ms.ToArray();  </li><li class="">   </li><li class="alt">                    string q = "insert into tb_produits (Image) values('" + img+ "')";  </li></ol></div></div><div>Here is to retrieve the picture : </div><div> <div class="dp-highlighter"><ol start="1" class="dp-c"><li class="alt">public static Bitmap ByteToImage(byte[] blob)  </li><li class="">        {  </li><li class="alt">            MemoryStream mStream = new MemoryStream();  </li><li class="">            byte[] pData = blob;  </li><li class="alt">            mStream.Write(pData, 0, Convert.ToInt32(pData.Length));  </li><li class="">            Bitmap bm = new Bitmap(mStream, false);  </li><li class="alt">            mStream.Dispose();  </li><li class="">            return bm;  </li><li class="alt">   </li><li class="">        }  </li><li class="alt">   </li><li class=""> MySqlDataAdapter sda = new MySqlDataAdapter("SELECT * FROM tb_produits WHERE Designation='" + Designation + "'and Reference='" + Reference + "'", MyConnexion);  </li><li class="alt">            DataTable dt = new DataTable();  </li><li class="">   </li><li class="alt">            sda.Fill(dt);  </li><li class="">            if (dt.Rows.Count == 1)  </li><li class="alt">            {  </li><li class="">                byte[] img = (byte[])dt.Rows[0]["Image"];  </li><li class="alt">   </li><li class="">               </li><li class="alt">   </li><li class="">                </li><li class="alt">                PIC_Image.Image = ByteToImage(img);  </li><li class="">            }  </li></ol></div></div><div>I tried to retrieve but I got an error: Parameter is not valid in this line " Bitmap bm = new Bitmap(mStream, false);"</div><div> </div>