Pdf file from database to view in asp.net mvc

Question

I have Image column in Ms Sql Database.Pdf files are in that column.

public ActionResult Index()
{
DatabaseEntities _ context = new DatabaseEntities();


var PdfFile = _context.FileTable.where(p=>p.Id==1).Select(s=>s.FileData).FirstOrDefault();


return view();
}

I select file's Byte and set it to "var PdfFile"

But i am not sure how can i call PdfFile in view and display inside html div in asp.net mvc ?

Any help will be greatly appreciated.

Thanks.

You need to actually display it in a div or just open it?

aw04
– aw04

2014-04-12 19:38:24 +00:00
Commented Apr 12, 2014 at 19:38 — aw04
– aw04, Commented Apr 12, 2014 at 19:38
thanks for answer.I need to display it in a div.

user3527568
– user3527568

2014-04-12 19:38:57 +00:00
Commented Apr 12, 2014 at 19:38 — user3527568
– user3527568, Commented Apr 12, 2014 at 19:38

Transcendent · Accepted Answer · 2014-04-12 20:09:31Z

6

You have make use of ViewData. Although I'm not sure how exactly you'er gonna display the pdf but to answer the question add this in your method:

 ViewData["PDF"] = PDFFile;

and in the razor you can get it this way:

@var getData = ViewData["PDF"];

To Display it, first convert it to base64:

<object data="data:application/pdf;base64,@System.Convert.ToBase64String((Byte[])ViewData["PDF"])" type="application/pdf" width="500px">
<embed src="data:application/pdf;base64, @System.Convert.ToBase64String((Byte[])ViewData["PDF"])" type="application/pdf" />
</object>

edited Apr 12, 2014 at 20:09

answered Apr 12, 2014 at 19:40

Transcendent

5,8054 gold badges26 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

user3527568 Over a year ago

I tried your code it did not work . do you have any idea why does not work?

user3527568 Over a year ago

PDFFile has byte so how can i display pdf file in view ?

aw04 Over a year ago

@CMonster Interesting, I've never seen that. It works though?

user3527568 Over a year ago

It works!!! thanks but i have one more question.In below side of pdf , there are zoom in zoom out etc etc(menu).How can i hide menu ?

Transcendent Over a year ago

@user3527568: Happy I helped you, you can accept the answer if you'd like to anyways ;)

|

Collectives™ on Stack Overflow

Pdf file from database to view in asp.net mvc

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related