I have an application that i've written in asp.net that allows a user to select a 1 page PDF file from their computer and upload it to a SQL Server database. A second application I've written retrieves the PDF file and displays it to a user.
There is a lot more to this application but these are the basic concepts of this problem. Ideally when the user of the first application hits the upload button I will call a stored procedure that passes in the PDF from their computer and stores it to the database.
Then when the user of the second application clicks a link I can retrieve the PDF file from the database and display it to the user. I've read that you can use VARBINARY data type to store the PDF but i'm not sure how to do this.
Has anyone done anything like this and could provide me some sample code? Any help you could offer would be appreciated.
You'll need a table in a SQL Server catalog: (CODE)You'll need a stored procedure to insert data into the SQL Table: (CODE)You'll need a page with an asp:FileUpload control to upload the file and parse
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…