To store Image in Sql server use following code:
Stream imgStream = FileUpload1.PostedFile.InputStream;
BinaryReader imgBinary = new BinaryReader(imgStream);
Byte[] bytes = imgBinary.ReadBytes((Int32)imgStream.Length);
imgBinary.Close();
imgStream.Close();
string imageName = FileUpload1.PostedFile.FileName;
string imgBinary = Convert.ToBase64String(bytes);
Now to retrieve and show the stored image from database, create new aspx page and put below code in Page_Load event.
string imgName = Request.QueryString["ImageName"].ToString();
string sql = "Select Img from TestImage where ImgName='" + imgName + "'";
SqlCommand myCommand = new SqlCommand(sql, con);
con.Open();
object objImage = myCommand.ExecuteScalar();
Response.Clear();
Response.ContentType = "image/jpeg";
Response.BinaryWrite((byte[])objImage);
Response.End();