Save Image in Database with C#

Question

Hello!

I saw the example Upload image to picturebox and write to database but I didn’t get that part:

FileStream Stream = new FileStream(imgLocation, FileMode.Open, FileAccess.Read);

What would this imgLocation be?

I’m getting the image of an html form.

Someone can help me?

Answer 1

On your model, you need a property of type IFormFile:

public class MyModel
{
    public IFormFile Arquivo {get;set;}
}

In your object, or POCO class, you need a property of type byte[]:

public class MyObject
{
    public byte[] Foto {get;set;}
}

And In your controller action, get Model, move to stream and then to byte[] and then saved on the bench:

    [HttpPost]
    [ValidateAntiForgeryToken]
    public async Task<IActionResult> Upload(MyModel model)
    {
        if (ModelState.IsValid)
        {
            MyObject obj = new MyObject();

            using (var memoryStream = new MemoryStream())
            {
                await model.Arquivo.CopyToAsync(memoryStream);
                obj.Foto = memoryStream.ToArray();
            }

            await _context.MyObjects.AddAsync(obj);
            _context.SaveChanges();
         }

         return View("Index");
    }

Don’t forget to add the property in the form enctype="multipart/form-data"

I hope I’ve helped.

Answer 2

Try like this Diego:

// Getting URL of the file to be downloaded and destination path // of the same

string urlArquivo =
    "http://www.minhapagina.com.br/imagens/foto.png";
string caminhoArquivo = 
    @"C:\Temp\Downloads\foto.png";

// Other code instructions...

// Downloading

System.Net.WebClient client =
    new System.Net.WebClient();
client.DownloadFile(urlArquivo, caminhoArquivo);

Then you pass the wayArch

FileStream Stream = new FileStream(caminhoArquivo, FileMode.Open, FileAccess.Read);