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; } }
|