winform把图片保存到数据库

  private void simpleButton1_Click(object sender, EventArgs e)
        {
            //上传相片
            OpenFileDialog oFileDialog1 = new OpenFileDialog();
            oFileDialog1.InitialDirectory = "c://";
            oFileDialog1.Filter = "Image Files(*.BMP;*.JPG;*.GIF)|*.BMP;*.JPG;*.GIF|All files (*.*)|*.*";
            oFileDialog1.FilterIndex = 1;
            oFileDialog1.RestoreDirectory = true;
            if (oFileDialog1.ShowDialog() == DialogResult.OK)
            {
                if (oFileDialog1.FileName != null)
                {
                    labPhotoPath.Text = oFileDialog1.FileName;
                    pePhoto.Image = Image.FromFile(oFileDialog1.FileName);
                }
            }
        }

 

        /// <summary>
        /// 把图片转换成字节格式
        /// </summary>
        /// <param name="fileName">图片名称</param>
        /// <returns></returns>
        public static byte[] ImageToStream(string fileName)
        {
            Bitmap image = new Bitmap(fileName);
            MemoryStream stream = new MemoryStream();
            image.Save(stream, System.Drawing.Imaging.ImageFormat.Bmp);
            return stream.ToArray();
        }

 

       //保存图片到数据库

            if (labPhotoPath.Text != null && labPhotoPath.Text != "")
            {
                entity.PHOTO =ImageToStream(labPhotoPath.Text);
            }

 

//从数据库读取图片并显示

             if (entity.PHOTO != null)
            {
                System.IO.MemoryStream ms = new System.IO.MemoryStream((byte[])entity.PHOTO.ToArray());
                System.Drawing.Image img = System.Drawing.Image.FromStream(ms);
                pePhoto.Image = new Bitmap(ms);
            }