保存到数据库(关键代码):
SQLiteParameter[] sqlParameters = {
new SQLiteParameter("@buyPicture",DbType.Binary),
new SQLiteParameter("@salePicture",DbType.Binary)
};
MemoryStream mstream = new MemoryStream();
dSkinPictureBox1.Image.Save(mstream, System.Drawing.Imaging.ImageFormat.Bmp);
byte[] byData = new Byte[mstream.Length];
mstream.Position = 0;
mstream.Read(byData, 0, byData.Length);
sqlParameters[0].Value = byData;
mstream.Close();
mstream = new MemoryStream();
dSkinPictureBox2.Image.Save(mstream, System.Drawing.Imaging.ImageFormat.Bmp);
byData = new Byte[mstream.Length];
mstream.Position = 0;
mstream.Read(byData, 0, byData.Length);
sqlParameters[1].Value = byData;
mstream.Close();
取出数据做为pictureBox数据源:
MemoryStream mStreamBuy = new MemoryStream(sqlReader["buyPicture"] as byte[]);
MemoryStream mStreamSeal = new MemoryStream(sqlReader["salePicture"] as byte[]);
dSkinPictureBox1.Image = Image.FromStream(mStreamBuy);
dSkinPictureBox2.Image = Image.FromStream(mStreamSeal);
mStreamBuy.Close(); // 关闭流
mStreamSeal.Close();