将图片转换成二进制存入到数据库

1.图片存到数据库

//fn为图片的URI
FileStream fs = new FileStream(fn, FileMode.OpenOrCreate, FileAccess.Read);
// 定义插入到数据库中的数据 buffer
buffer = new byte[fs.Length];
BinaryReader br = new BinaryReader(fs);
buffer = br.ReadBytes(Convert.ToInt32(fs.Length));                    
fs.Close();
fs.Dispose();

2.将图片取出

BitmapImage img = new BitmapImage();
if (buffer != null)
{
      MemoryStream ms = new MemoryStream(buffer);
      ms.Seek(0, SeekOrigin.Begin);

      img.BeginInit();
      img.StreamSource = ms;
      img.EndInit();
}
return img;