private byte[] imagedata=null;//this function is for retrieving data from mysql(blob)private byte[] getImage() { MySqlConnection objConn; objConn = new MySqlConnection("SERVER=localhost;" + "DATABASE=database;" + "UID=root;" + "PASSWORD=root;charset=utf8"); string strSql = "SELECT * FROM customers where id=" + this.id; DataSet ds = new DataSet(); MySqlDataAdapter tempAP = new MySqlDataAdapter(strSql, objConn); MySqlCommandBuilder objCommand = new MySqlCommandBuilder(tempAP); tempAP.Fill(ds, "customers"); try { objConn.Open(); byte[] buffer = (byte[])ds.Tables["customers"].Rows[0][13]; return buffer; } catch { objConn.Close(); return null; } finally { objConn.Close(); } }//this function read from file to byte[]private byte[] ReadFile(string sPath) { byte[] data = null; FileInfo fInfo = new FileInfo(sPath); long numBytes = fInfo.Length; FileStream fStream = new FileStream(sPath, FileMode.Open, FileAccess.Read); BinaryReader br = new BinaryReader(fStream); data = br.ReadBytes((int)numBytes); return data; }//browse resize upload image (WORKS)private void button5_Click(object sender, EventArgs e) { pictureBox1.SizeMode = System.Windows.Forms.PictureBoxSizeMode.AutoSize; string imageName = GenerateId(); imageName = imageName + ".jpg"; this.slika = imageName; OpenFileDialog open = new OpenFileDialog(); open.Filter = "Image Files(*.jpg; *.jpeg; *.gif; *.bmp)|*.jpg; *.jpeg; *.gif; *.bmp"; if (open.ShowDialog() == DialogResult.OK) { System.Reflection.Assembly exe = System.Reflection.Assembly.GetEntryAssembly(); string exePath = System.IO.Path.GetDirectoryName(exe.Location); string fullImageName = exePath +"\\images\\"+ imageName; ResizeImage(open.FileName, fullImageName , 240, 240, false); imagedata = ReadFile(fullImageName); System.IO.MemoryStream stream1 = new System.IO.MemoryStream(imagedata, true); stream1.Write(imagedata, 0, imagedata.Length); Bitmap m_bitmap = (Bitmap)Bitmap.FromStream(stream1); pictureBox1.Image = m_bitmap; } }
Then i insert imagedata into database
mysql_cmd.CommandText = "insert into customers (image) Values ('" + imagedata + "')";
imagedata = getImage();if (imagedata != null){System.IO.MemoryStream stream1 = new System.IO.MemoryStream(imagedata, true);stream1.Write(imagedata, 0, imagedata.Length);Bitmap m_bitmap = (Bitmap)Bitmap.FromStream(stream1);pictureBox1.Image = m_bitmap;}