PDF file convert to MDB

Question

Dear sir I have a task to uplode PDF file data store in/convert Microsoft Sql Server database . if have any solution plz reply me .ASAP

Maen Badwan · Answer

Do you mean you want to save the PDF data in an SQL server database? If yes, I think you can do this as follows: 1. Create a new field of type VarBinary(Max) in your database table. 2. In your C# code, read the PDF data into a byte array using the ReadAllBytes method as follows: -------------------------------------------------------------------------- byte[] PDFfileBytes = System.IO.File.ReadAllBytes(@"Source.pdf"); -------------------------------------------------------------------------- 3. Insert the PDF byte array in the database using the SQL Insert statement. After this, you can read it back from the database into a byte[], and save this byte[] array to a file on disk using the System.IO.File.WriteAllBytes method. Now, if you are looking for a way to display the PDF files after Loading them back from the database, you can use a programming toolkit (like LEADTOOLS) to load the PDF file and display it on a viewer. You can find more details here: https://www.leadtools.com/help/leadtools/v19/dh/javascript/to/leadtools.topics.documents.ui~doxui.topics.documentviewer_using.html Disclaimer: I am employee of the LEADTOOLS product