protected void GET_OFFICER_HEADSHOT(string query, string record_guid) { DataTable dt = HeadShotEngine.SELECT_OFFICER_HEAD_SHOT(query, record_guid); if (dt == null || dt.Rows.Count == 0) { this.picBoxImage.Image = null; } else { DataRow dtRow = dt.Rows[0]; if (dtRow["image_data"] != DBNull.Value) { MemoryStream stream = new MemoryStream((byte[])dtRow["image_data"]); this.picBoxImage.Image = Image.FromStream(stream); return; } } }
private void btnSave_Click(object sender, EventArgs e) { if (this.picBoxImage.Image == null) { MessageBox.Show("No Image selected"); return; } try { Image img = this.picBoxImage.Image; byte[] arr = (byte[])(new ImageConverter()).ConvertTo(img, typeof(byte[])); HeadShotEngine.INSERT_OR_UPDATE_IMAGE("UPDATE_GUARD_IMAGE_LARGE", this.lbl_guid.Text, arr); MessageBox.Show("Update Successfull"); } catch (Exception exception) { MessageBox.Show(exception.ToString()); } }
protected void GET_OFFICER_HEADSHOT(string query, string record_guid) { DataTable dt = HeadShotEngine.SELECT_OFFICER_HEAD_SHOT(query, record_guid); if (dt != null && dt.Rows.Count != 0) { DataRow dtRow = dt.Rows[0]; if (dtRow["image_data"] != DBNull.Value) { byte[] data = (Byte[])dtRow["image_data"]; MemoryStream stream = new MemoryStream(data); picBoxImage.Image = Image.FromStream(stream); } } else { picBoxImage.Image = null; } }
private void btnSave_Click(object sender, EventArgs e) { if (picBoxImage.Image == null) { MessageBox.Show("No Image selected"); } else { try { Image img = picBoxImage.Image; byte[] arr; ImageConverter converter = new ImageConverter(); arr = (byte[])converter.ConvertTo(img, typeof(byte[])); HeadShotEngine.INSERT_OR_UPDATE_IMAGE("UPDATE_GUARD_HEAD_SHOT", lbl_guid.Text, arr); MessageBox.Show("Update Successfull"); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } }