HttpPostedFileBase to varbinary(max)

Question

I have just tried a lot of things that I found but at the end nothing successfull.

First I have the next code that just do the things ok but dont save the image.

What should I do to save an image into a varbinarymax? and how to show them to the view next?

view:

<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>

Controller:

[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);
}

Model:

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; }
}

score 1 · Answer 1 · answered Feb 28 '16 at 19:45

Change View First to This:

@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>
}

Change Action To This:

[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);
    }
}

Now This Logo Save It.

Amit Kumar · Answer 2 · 2016-02-28T18:57:50.087

As you don't have posted complete form, here is complete code to upload image and save into DB.

you form must have enctype property.

@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" />
}

And inside your action.

[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);
}

It will save file in your Db.

HttpPostedFileBase to varbinary(max)

2 Answers2