将图片以二进制流保存到数据库中

 

 

  public Form1()
        {
            InitializeComponent();
        }

        private void btnSelect_Click(object sender, EventArgs e)
        {
            personPicture.Filter = "*.gif|*.png|*.jpeg|*.jpg";
            personPicture.ShowDialog();
        }

        private void personPicture_FileOk(object sender, CancelEventArgs e)
        {
            Image img = Image.FromStream(personPicture.OpenFile(), false);
            this.pictureBox1.Image = img;
        }

        private void btnSave_Click(object sender, EventArgs e)
        {
            using (DXDataContext db = new DXDataContext())
            {
                MemoryStream ms = new MemoryStream();
                pictureBox1.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
                byte[] imgdata = ms.GetBuffer();
                Person p = new Person();
                p.Name = this.textBox1.Text.Trim();
                p.Picture = imgdata;
                db.Person.InsertOnSubmit(p);
                db.SubmitChanges();
            }
        }

        private void button1_Click(object sender, EventArgs e)
        {
            using (DXDataContext db = new DXDataContext())
            {
                var per = db.Person.ToList<Person>().First();
                MemoryStream ms = new MemoryStream(per.Picture.ToArray());
                Image img = Image.FromStream(ms);
                this.pictureBox1.Image = img;
            }
        }
    }
}

 

前端显示代码

 MemoryStream ms = new MemoryStream();
                pictureBox1.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
                byte[] imgdata = ms.GetBuffer();
                Person p = new Person();
                p.Name = this.textBox1.Text.Trim();
                p.Picture = imgdata;

 var per = db.Person.ToList<Person>().First();
                MemoryStream ms = new MemoryStream(per.Picture.ToArray());
                Image img = Image.FromStream(ms);
                this.pictureBox1.Image = img;

/*---------------------------------------------------------------------------------*/