Click here to Skip to main content
15,895,084 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
How to select pictures from a database and show in a picture box?
i tried linq to entity worked well for all types of records but problem is to how to select images from a database table?
i tried

C#
using (dbe =new DatabaseEntities())
      {
          var images = from p in dbe.PitureTables
                       select p.Picture;
          foreach (var image in images)
          {
              MessageBox.Show("foreach Run");
              pictureBox2.Image = Image.FromStream(new MemoryStream(image.ToArray()));
          }
      }

there is no any error but the foreach loop wont run, before this block of code i have inserted an image as following
C#
using (dbe = new DatabaseEntities())
           {
              PitureTable record= new PitureTable {PictureName="pic1",Picture=imageToByteArray( pictureBox1.Image)};
                    dbe.StudentRecords.AddObject(record);
                    db.StudentRecords.Attach(record);
                    dbe.SaveChanges();
                    MessageBox.Show("inserted");
                }
Posted
Updated 4-Jan-13 8:23am
v2

1 solution

Usually I answer most of questions in more or less fine detail, so I'm sorry that I don't do it in this case. The reason is: this question is way, way too popular, and CodeProject keeps many answers to it, answered again and again. Please, just look here:
http://www.codeproject.com/search.aspx?doctypeid=4%3b5&q=database+%28image+OR+picture%29+%28store+OR+get+OR+retrieve%29+PictureBox[^].

You can find more if you remove PictureBox from the query, because it's pretty much irrelevant.

Good luck,
—SA
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900