Upload File and save it in DB

Harlem 98

Hello commnunity.

I am trying to upload and save a file in DB, which i am not being able of. Can you tell what is wrong in my code?

//My upload file method

protected void UploadSampleFile_Click(object sender, EventArgs e)
{
    foreach (UploadedFile file in RadAsyncUploadSample.UploadedFiles)
    {
        RadAsyncUploadSample.Visible = false;
        UploadSampleFile.Visible = false;
        TemplateFile model = new TemplateFile();
        model.FileNameT = Path.GetFileNameWithoutExtension(file.FileName); //obter o nome do ficheiro do cliente
        model.FileTipoT = Path.GetExtension(file.FileName);
        file.InputStream.Position = 0;
        model.FileContentT = new byte[file.InputStream.Length];
        for (int totalBytesCopied = 0; totalBytesCopied < file.InputStream.Length; )
            totalBytesCopied += file.InputStream.Read(model.FileContentT, totalBytesCopied, Convert.ToInt32(file.InputStream.Length) - totalBytesCopied);
        int IDTemplate = templatebll.SaveFile(model);


//My BLL save file method

public int SaveFile(TemplateFile model)
{
    try
    {
        using (GestaoProjectosEntities lt = new GestaoProjectosEntities())
        {
            lt.TemplateFiles.AddObject(model);
            lt.SaveChanges();
            return model.IDTemplate;

        }
    }
}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh4y ago
Accepted answer
for that use
foreach (UploadedFile file in RadAsyncUploadSample.UploadedFiles)
    {
        RadAsyncUploadSample.Visible = false;
        UploadSampleFile.Visible = false;
        TemplateFile model = new TemplateFile();
        model.FileNameT = Path.GetFileNameWithoutExtension(file.FileName);
        model.FileTipoT = Path.GetExtension(file.FileName);

        int fileSize = file.ContentLength;

float length = float.Parse(fileSize.ToString());
byte[] fileData = new byte[file.InputStream.Length];
file.InputStream.Read(fileData, 0, (int)file.InputStream.Length);
model.FileContentT = fileData ;

        int IDTemplate = templatebll.SaveFile(model);

}
Harlem 984y ago
Hi Sachin

My property is byte[], because i want in deed save the file content.

I try to convert do the necessary convertion with input stream, but something is missing. Can you identity what it is?
Vikas Panwar4y ago
check this lik

https://www.c-sharpcorner.com/UploadFile/009464/save-image-to-database-using-fileupload-in-Asp-Net/
Sachin Singh4y ago
Either you can store byte[] as file content, or filepath in your database.
You are using Entity Framework, so first varify whether your model's property is string or byte[], then accordingly we can answer, how should you proceed.
As i can guess, you want to store file path in database and file inside a folder. for this follow below approach
protected void UploadSampleFile_Click(object sender, System.EventArgs e)
{
  foreach (UploadedFile f in RadAsyncUpload1.UploadedFiles)
  {
      f.SaveAs( "\Uploads\" + f.GetName(), true);
int IDTemplate = templatebll.SaveFile(new TemplateFile()
{
Path= "\Uploads\"+f.GetName();
FileName=f.Getname();
});
  }
}
public int SaveFile(TemplateFile model)
{
    try
    {
        using (GestaoProjectosEntities lt = new GestaoProjectosEntities())
        {
            lt.TemplateFiles.AddObject(model);
            lt.SaveChanges();
            return model.IDTemplate;

        }
    }
}

public class TemplateFile
{
public string FileName{get;set;}
public string Path{get;set;}

}