• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 941
  • Last Modified:

retrieve sql image data type into asp.net display

I need to retrieve a image field from a sql database into some to display it in my asp.net app..

any suggestions on how to do this?
0
vbnetcoder
Asked:
vbnetcoder
  • 2
1 Solution
 
Rahul AgarwalTeam LeaderCommented:

http://www.codeproject.com/KB/database/ImageSaveInDataBase.aspx
http://social.msdn.microsoft.com/Forums/en/adodotnetdataproviders/thread/deb976d4-0678-4411-8e76-be2a7f5f280b

Example:
// imageData retrieve from SQL Server
                byte[] imageData = GetBytesFromUrl("http://student.kfupm.edu.sa/s200354630/Multi/images/o-png8.png");
                MemoryStream stream = new MemoryStream(imageData);

                System.Drawing.Image img = System.Drawing.Image.FromStream(stream);

                Response.Clear();
                Response.ContentType = "image/jpg";
                img.Save(Response.OutputStream, ImageFormat.Jpeg);
                img.Dispose();
0
 
vbnetcoderAuthor Commented:
I used the code in the first link and it did not like this line:

 pictureBox1.Image = Image.FromFile(strfn)

it said that .fromfile was not a member of system.web.ui.webcontrols.image
0
 
vbnetcoderAuthor Commented:
ty
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now