File Downlaod Problem in .net core

U Thu

My project is DL project.This project store data and upload file.sql database of FileUploadPath is store upload file name.Upload progress is Ok.But download this DL PDF File progress is problem in now time.I would like to download link buttion click DL PDF Downloaded to Computer.This download file click action chtml is look like this

@Html.DisplayFor(modelItem => item.Confirm.ApprovedStatus)

Download

Edit |
Details |
Delete

Nex this route is item.ID therefore Download Action is LookLike this

public FileResult Download(int id)
{
var Getfilename = _context.REHPData.FromSql("SELECT UploadFilePath" +
"FROM REHPData " +
"WHERE ID IN (@p0)", id);
string uploadpath = Path.Combine(_environment.WebRootPath, "UploadFiles");
var FilePath = Path.Combine(uploadpath, Getfilename.ToString());
return File(FilePath, "application/pdf");

}

This above action method using SELECT method.Really not using this style,I am using store procedure Below run application ID column is requierd present error

public FileResult Download(int id)
{
var parameter = new SqlParameter("@Id", id);

var Getfilename = _context.REHPData.FromSql("EXEC FileDownloadProcedure @Id", parameter).Single();

var filepath = Path.Combine(_environment.WebRootPath, "UploadFiles", filename.ToString());

return File(filepath, "application/pdf");

}

Please help me and code errror.

My sql StoreProcedure look like this :

CREATE PROCEDURE [dbo].[FileDownloadProcedure]
@param1 int
AS
SELECT UploadFilePath FROM DBO.REHPData WHERE ID= @param1
RETURN 0

2 Replies

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

U Thu8y ago
i am modified code look lik this

1.sql procedure code
CREATE PROCEDURE [dbo].[FileDownload]
@ID int
AS
SELECT UploadFilePath FROM DBO.REHPData WHERE ID= @ID

RETURN 0

2.Download link in view index.chtml code

Download

Edit |
Details |
Delete

3.Controller Download Method Code is
public FileResult Download(int id)
{
var Parameter = new SqlParameter("@ID", id);
var GetFileName = _context.REHPData.FromSql("EXEC dbo.FileDownload @ID", Parameter).Single();
var Filepath = Path.Combine(_environment.WebRootPath, "UploadFiles", GetFileName.ToString());
string ContentType = string.Empty;
if(Filepath.Contains(".pdf"))
{
ContentType= "application/pdf";
}
else if (Filepath.Contains(".docx"))
{
ContentType = "application/docx";
}
return File(Filepath, ContentType);
}
4.Run Application and Index.chtml of download link clicked is this vs2017 in error look like this.

System.InvalidOperationException: 'The required column 'ID' was not present in the results of a 'FromSql' operation.'
5.Pleas help me teachers.
0
Nilesh Shah8y ago
in your SP, the parameter name is @param1, but you are passing @Id as parameter,
that's why you get the error.

change your following two lines :
var parameter = new SqlParameter("@Id", id);
var Getfilename = _context.REHPData.FromSql("EXEC FileDownloadProcedure @Id", parameter).Single();
to these lines:
var parameter = new SqlParameter("@param1", id);
var Getfilename = _context.REHPData.FromSql("EXEC FileDownloadProcedure @param1", parameter).Single();
0