更新Linq查询图像(文件上传)

本文关键字：文件 Linq 查询 图像 更新 | 更新日期: 2023-09-27 18:01:36

如何为更新设置true查询?我找不到这个零件

 var image = add.Image.ToArray();

我必须从UserImage得到图像列

            string fileName = FileUpload1.FileName;
            byte[] fileByte = FileUpload1.FileBytes;
            Binary binaryObj = new Binary(fileByte);
            var add = from u in db.UserImage
                          where u.User_Id == id
                          select u;
            foreach (var u in update7)
            {
                u.Image = binaryObj;
                u.ImageObj = fileName;
            }   

            db.SubmitChanges();
            var image =*add.Image*.ToArray();
            byte[] foto = (byte[])image;
            TypeConverter cc = TypeDescriptor.GetConverter(typeof(Bitmap));
            Bitmap my = (Bitmap)cc.ConvertFrom(foto);
            string img = Convert.ToBase64String(foto);
            Image1.ImageUrl = string.Format("data:image/Bmp;base64,{0}", img);

更新Linq查询图像(文件上传)

你能试试这个吗?只是我的两分钱。

var add = from u in db.UserImage
          where u.User_Id == id
          select u;
foreach (var u in add)
{
   u.Image = binaryObj;
   u.ImageObj = fileName;
}
db.SaveChanges();

我解决了

            var add = (from u in db.UserImage
                       where u.User_Id == id
                       select u).ToList();
            foreach (var u in add)
            {
                u.Image = binaryObj;
                u.ImageObj = fileName;
            }

            db.SubmitChanges();
            var image = add[0].Image.ToArray();
相关文章：