ASP.NET

SqlConnection con = new SqlConnection(connectionstring);<br />
        con.Open();<br />
  SqlCommand cmd=new SqlCommand();<br />
        cmd.CommandText = "spSelect_a";<br />
        cmd.Connection = con;<br />
        cmd.CommandType = CommandType.StoredProcedure;<br />
        DataSet ds = new DataSet();<br />
        SqlDataAdapter ad = new SqlDataAdapter(cmd);<br />
        ad.Fill(ds);<br />
        byte[] b = (byte[])cmd.ExecuteScalar();<br />
        MemoryStream ms = new MemoryStream();<br />
        ms.Write(b, 0, b.Length);<br />
        Bitmap bmp = new Bitmap(ms);     <br />
   bmp.Save(Response.OutputStream,ImageFormat.Bmp);