Use pdf viewer with a document stored in a database

[Guillermo Goberna]

I would like to use the pdf viewer 

 @Html.EJS().PdfViewer("pdfviewer").ServiceUrl(VirtualPathUtility.ToAbsolute("~/PdfViewer/")).Render()

But the document is not stored in a folder in the webserver, it is stored in a database, so I need to retrieve the document from the database (not a problem) and load the document in the pdfviewer component.

Could you provide an example? 

Thank you.

I'm using the controller and razor view from your website: 

https://ej2.syncfusion.com/aspnetmvc/documentation/pdfviewer/getting-started/

[Ramya Thirugnanam]

Hi Guillermo, 

 

Thanks for contacting Syncfusion support. 

  

PDF viewer supports to load the PDF document from database as base64 string using the documentPath API.  

  

The below code example will get the PDF document as byte array using its name from the Database and converts the same into base64 string. 

 

public object GetDocument() 

        { 

            string documentID = "Xyz.pdf"; 

            string constr = System.Configuration.ConfigurationManager.ConnectionStrings["PdfDocument"].ConnectionString; 

            System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(constr); 

            //Searches for the PDF document from the Database 

            var query = "select Data from PdfDocuments where DocumentName = '" + documentID + "'"; 

            System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(query); 

            cmd.Connection = con; 

            con.Open(); 

            System.Data.SqlClient.SqlDataReader read = cmd.ExecuteReader(); 

            read.Read(); 

            // Reads the PDF document data as byte array from the database 

            byte[] byteArray = (byte[])read["Data"]; 

            //converts byte array into base64 string 

            return "data:application/pdf;base64," + Convert.ToBase64String(byteArray); 

  

        }  

  

Note: Kindly modify the Database name and their entries as per your database entries. 

  

We have created the sample to load the base64 string in PDF viewer and shared the same in the following link,  

  

http://www.syncfusion.com/downloads/support/directtrac/general/ze/EJ2PDFViewer_Sample-720713875  

  

In the preceding sample, clicking on the ‘Load PDF document as Base64String’ will get PDF document from the local disk as base64 string in GetDocument() and load it in PDF viewer using documentPath. Similarly, you can get the PDF document from database and load it into the PDF Viewer. 

  

Regards, 

Ramya T 

[Guillermo Goberna]

Thank you very much,

I left here also the code in case is useful for anyone else: 

View: 

<div style="height:800px;width:100%;">
       @Html.EJS().PdfViewer("pdfviewer").ServiceUrl(VirtualPathUtility.ToAbsolute("~/PDF/")).DocumentPath(ViewBag.Documento).Render()
</div>

Controller:

        public ActionResult Visor(int id)
        {

            // Reads the PDF document data as byte array from the database (DBtm is the dbml class that connects to the Documents database)
            byte[] byteArray = DBtm.Documents.First(x => x.IdDocument == id).Document.ToArray();

            //converts byte array into base64 string

            ViewBag.Documento = "data:application/pdf;base64," + Convert.ToBase64String(byteArray);
            return View();
        }

[Ramya Thirugnanam]

Hi Guillermo,  

 

Thanks for your update. 

 

Regards,   

Ramya T   

[MIMS IT]

Hello, 

Can you help with loading the pdf from azure blob storage url.

MIMS IT

[Akshaya Arivoli]

Hi ,

Thank you for contacting Syncfusion support. 

We can load the PDF document’s blob URL in PDF Viewer, by converting the URL to base64 string using the client-side load() API in the sample level. Please find the below link for reference, 

https://www.syncfusion.com/kb/10549/how-to-load-pdf-document-from-online-url-in-pdf-viewer  

Please try this and revert us if you have any concerns on this. 

Regards, 

Akshaya