从数据库中存取图片

        public static byte[] GetBytesFromImage(Image image, ImageFormat format)
        {
            try
            {
                MemoryStream ms = new MemoryStream();
                image.Save(ms, format);
                return ms.GetBuffer();
            }
            catch (System.Exception e)
            {
                throw new System.Exception("处理图像时发生错误!错误原因:" + e.Message);
            }
        }

 

public void SaveImage()

{

          Image img1 = (Image)Resources._2;
          byte[] bytes= GetBytesFromImage(img1, ImageFormat.Png);

          SqlConnection conn = SqlHelper.GetConnection();

          SqlCommand cmd = new SqlCommand();
          cmd.Connection = conn;
          cmd.CommandText = "update Test set Image=@Image";
          cmd.Parameters.Add("@Image", SqlDbType.Image);

          cmd.Parameters[0].Value = str1;

          cmd.ExecuteNonQuery();

          conn.Close();

}

 

        public static Image GetImageFromBytes(byte[] bytes)
        {
            //读取图象
            byte[] BLOBData = bytes;
            MemoryStream MsBLOBData = null;
            try
            {
                MsBLOBData = new MemoryStream(BLOBData);
                return Image.FromStream(MsBLOBData);
            }
            catch (Exception e)
            {
                throw new System.Exception("转换图像时发生错误!错误原因:" + e.Message);
            }
        }

 

public void GetImage()

{

            string CmdText = "Select Image from test where id=1";

            pictureBox1.Image= GetImageFromBytes((byte[])SqlHelper.ExecuteScalar(CmdText));

}

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值