Create a table in a SQL Server database which has at least one field of type IMAGE.
Here is the script :

CREATE TABLE [dbo].[tblImgData] ([ID] [int] NOT NULL ,[Name] [varchar]
(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Picture] [image]
NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

The IMAGE field is just holding the reference to the page containing the binary data so we have to convert our image into bytes.

By using FileInfo class, retrieved the file size:
FileInfo fiImage=new FileInfo(strFn);

Declare an array of that size:
this.m_lImageFileLength=fiImage.Length;
m_barrImg=new byte[Convert.ToInt32(this.m_lImageFileLength)];

By using FileStream object, I filled the byte array:
FileStream fs=new FileStream(strFn,FileMode.Open, FileAccess.Read,FileShare.Read);
int iBytesRead=fs.Read(m_barrImg,0, Convert.ToInt32(this.m_lImageFileLength));

Saving byte array data to database.

execute non-query for saving the record to the database.
int iresult=this.sqlCommand1.ExecuteNonQuery();

Retrieving images from the database is the exact reverse process of saving images to the database.

Open database connection and execute “ExecuteScalar” because we want only “IMAGE” column data back.
byte[] barrImg=(byte[])cmdSelect.ExecuteScalar();

Save this data to a temporary file.
string strfn=Convert.ToString(DateTime.Now.ToFileTime());
FileStream fs=new FileStream(strfn,FileMode.CreateNew,FileAccess.Wri te);
fs.Write(barrImg,0,barrImg.Length);
fs.Flush();

And display the image anywhere you want to display.
pictureBox1.Image=Image.FromFile(strfn);