{strBLOBFilePath = opnFileBoxImage.FileName;

pictureBox1.Image = Image.FromFile(strBLOBFilePath);

}}

==================================================

(Save Image file in to SQL server)

note :- ( create table imageTable (empid int, img image))

private void button1_Click(object sender, System.EventArgs e)

MemoryStream ms = new MemoryStream();
PictureBox1.Image.Save(ms, PictureBox1.Image.RawFormat);
byte[] bytes = ms.GetBuffer;
SqlConnection con = new SqlConnection("server=SERVERNAME;database=DATABASENAME;user id=SA; password=");
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "insert imagetable values(@img)";
cmd.Parameters.Add(new SqlParameter("@img", SqlDbType.Image)).Value = bytes;
cmd.ExecuteNonQuery();
con.Close();}

=========================================

(retreive image from SQL server)

(button click)

sqlconnection con = new sqlconnection(connectionPath);
sqlcommand cmd1 = new sqlcommand("Select img from imageTable", con);
sqldataadapter da = new sqldataadapter(cmd1);
dataset ds = new dataset();
da.fill(ds, "ima");
byte[] bytes = ((Bytes)(ds.tables(0).rows(0)(0)));
memortstream ms = new memortstream(bytes);
picturebox1.image = picturebox1.image.fromstream(ms);
picturebox1.refresh();