How to save image into database

Question

Hi How can I save image into database and retrieve image at front-end form database in ado.net? Thanks.

Satyapriya Nayak · Answer

Hi Alok Please refer Our recommended articles. Thanks

Datta Kharad · Answer

Hi I have done using oracle database. using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.OracleClient; using System.IO; using System.Drawing.Imaging; namespace Insert_Application { public partial class frm_insert : Form { OracleConnection con; OracleCommand cmd; MemoryStream ms; OracleDataReader dr; OracleDataAdapter da; DataSet ds; public frm_insert() { InitializeComponent(); } private void btnclear_Click(object sender EventArgs e) { clearfield (); } public void clearfield() { txtename .Text =txtsalary .Text = ; } private void btnclose_Click(object sender EventArgs e) { this.Close(); } private void frm_insert_Load(object sender EventArgs e) { con = new OracleConnection(Data Source=ndsinsur; User ID=vbproj; Password=vbproj); con.Open(); incrementid(); cmd.CommandText = select eid from empdbimg; cmd.Connection = con; dr = cmd.ExecuteReader(); while (dr.Read()) { comboBox1.Items.Add(dr[0]); } dr.Close(); } public void incrementid() { cmd = new OracleCommand(); cmd.CommandText = select MAX(eid+1) from empdbimg; cmd.Connection = con; dr = cmd.ExecuteReader(); while (dr.Read()) { txteid.Text = dr[0].ToString(); } dr.Close(); txtename.Focus(); } private void btnsave_Click(object sender EventArgs e) { cmd = new OracleCommand(); cmd.Parameters.Clear(); cmd.CommandType = CommandType.Text; cmd.CommandText = insert into empdbimg(eidenamesalaryhiredatephoto)values(:eid:ename:salary:hiredate:photo); cmd.Parameters.Add (:eidtxteid .Text ); cmd.Parameters.Add (:enametxtename .Text ); cmd.Parameters.Add(:salary txtsalary.Text); cmd.Parameters.Add (:hiredatedtp1 .Text ); //Save image into database ms = new MemoryStream(); pictureBox1 .Image .Save(ms ImageFormat .Jpeg ); byte[] photo = new byte[ms.Length]; ms.Position = 0; ms.Read(photo 0 (int)ms.Length); cmd.Parameters.Add(:photophoto ); cmd.Connection = con; cmd.ExecuteNonQuery(); MessageBox.Show(Record Has Saved Successfully...!!!); clearfield (); incrementid(); } private void btnphotoload_Click(object sender EventArgs e) { OpenFileDialog ofd = new OpenFileDialog(); ofd.Title = Open Image File; ofd.Filter = Bitmap Files|*.bmp + |Gif Files|*.gif|Icons|*.ico|JPEG Files|*.jpg + |PNG Files|*.png|TIFF Files|*.tif; ofd.ShowDialog(); if (ofd.ShowDialog() == DialogResult.OK) { txtimgpath.Text = ofd.FileName; } else { MessageBox.Show(Please select image); } pictureBox1.ImageLocation = txtimgpath.Text; pictureBox1.Show(); } private void comboBox1_SelectedIndexChanged(object sender EventArgs e) { cmd.Parameters.Clear(); cmd.CommandText = select * from empdbimg where eid=:eid; cmd.Parameters.Add(:eid comboBox1.SelectedItem.ToString()); da = new OracleDataAdapter(cmd); ds = new DataSet(); da.Fill(ds empdbimg); cmd.Connection = con; if(ds.Tables [0].Rows .Count >0) { txtename.Text = ds.Tables [0].Rows [0][1].ToString (); txtsalary.Text = ds.Tables [0].Rows [0][2].ToString(); dtp1.Text = ds.Tables[0].Rows[0][3].ToString(); //Here Read Image from database byte[] photo = (byte [])ds.Tables[0].Rows[0][4]; ms = new MemoryStream(photo); pictureBox1.Image = Image.FromStream(ms); } dr.Close(); con.Close(); } } }

Mukesh Kumar · Answer

Hi Check this link http://www.codeproject.com/KB/database/ImageSaveInDataBase.aspx