How to save image into database

Hi Alok,


Please refer Our recommended articles.



Thanks

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(eid,ename,salary,hiredate,photo)values(:eid,:ename,:salary,:hiredate,:photo)";
cmd.Parameters.Add (":eid",txteid .Text );
cmd.Parameters.Add (":ename",txtename .Text );
cmd.Parameters.Add(":salary", txtsalary.Text);
cmd.Parameters.Add (":hiredate",dtp1 .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(":photo",photo );
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();
}
}
}

Hi,

Check this link

http://www.codeproject.com/KB/database/ImageSaveInDataBase.aspx