HttpPostedFileBase to varbinary(max)

本文关键字:max varbinary to HttpPostedFileBase | 更新日期: 2023-09-27 18:36:46

我刚刚尝试了很多我发现的东西,但最后没有成功。

首先,我有下一个代码,它只是做一些事情,但不保存图像。

我应该怎么做才能将图像保存到 varbinarymax 中? 接下来如何将它们显示给视图?

视图:

<div class="form-group">
  @Html.LabelFor(model => model.Logo, htmlAttributes: new { @class = "control-label col-md-2" })
  <div class="col-md-10">
    @*@Html.EditorFor(model => model.Logo, new { htmlAttributes = new { @class = "form-control" } })*@
    @Html.TextBoxFor(model => model.Logo, new { type = "file" })
    @Html.ValidationMessageFor(model => model.Logo, "", new { @class = "text-danger" })
  </div>
</div>

控制器:

[HttpPost]
[ValidateAntiForgeryToken]
public async Task<ActionResult> Create([Bind(Include = "Id,Name,Address,Description,Mail,Phone,Small_Description")] School school)
{
  if (ModelState.IsValid)
  {
    db.School.Add(school);
    await db.SaveChangesAsync();
    return RedirectToAction("Index");
  }
  return View(school);
}

型:

public partial class School
{
  [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
  public School()
  {
    this.Product = new HashSet<Product>();
  }
  public int Id { get; set; }
  public string Name { get; set; }
  public string Address { get; set; }
  public string Description { get; set; }
  public string Mail { get; set; }
  public int? Phone { get; set; }
  public byte[] Logo { get; set; }
  public string Small_Description { get; set; }
  [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
  public virtual ICollection<Product> Product { get; set; }
}

HttpPostedFileBase to varbinary(max)

首先将视图更改为:

@using (Html.BeginForm("Create", "Schole", FormMethod.Post, new { enctype = "multipart/form-data" }))
{
<div class="form-group">
  @Html.LabelFor(model => model.Logo, htmlAttributes: new { @class = "control-label col-md-2" })
<div class="col-md-10">
@Html.TextBoxFor(model => model.Logo, new { type = "file" })
   <input type="submit" value="submit" />
</div>
</div>
}

将操作更改为:

[HttpPost]
[ValidateAntiForgeryToken]
public async Task<ActionResult> Create([Bind(Include = "Id,Name,Address,Description,Mail,Phone,Small_Description")] School school, HttpPostedFileBase Logo)
    {
        if (ModelState.IsValid)
        {
            using (var memoryStream = new MemoryStream())
            {
                Logo.InputStream.CopyTo(memoryStream);
                school.Logo = memoryStream.ToArray();
            }
            db.School.Add(school);
            await db.SaveChangesAsync();
            return RedirectToAction("Index");
        }
        return View(school);
    }
}

现在这个标志保存它。

由于您没有发布完整的表单,这里是上传图像并保存到数据库中的完整代码。

窗体必须具有 enctype 属性。

@using (Html.BeginForm("Index","Home",FormMethod.Post, new{ enctype = "multipart/form-data" }))
{
    //your other code
    <input type="file" name="logo" />
    <input type="submit" value="Save" />
}

在你的行动中。

[HttpPost]
[ValidateAntiForgeryToken]
public async Task<ActionResult> Create([Bind(Include = "Id,Name,Address,Description,Mail,Phone,Small_Description")] School school)
{
  if (ModelState.IsValid)
  {
        byte[] fileData = null;
        using (var binaryReader = new BinaryReader(Request.Files["logo"].InputStream))
        {
            fileData = binaryReader.ReadBytes(Request.Files["logo"].ContentLength);
        }
    school.Logo=fileData;
    db.School.Add(school);
    await db.SaveChangesAsync();
    return RedirectToAction("Index");
  }
  return View(school);
}

它会将文件保存在您的数据库中。