how to retraive pdf file from sql server please give proper answer

Question

hi i want to save & retraive pdfdoc file from sql server using asp.net please send me a complete solution(in zip file) because i tired to solve this problem thanks regard

Santhosh Kumar Jayaraman · Answer

Please find the attached project. Here is the my table script. create table uploadtest ( id int primary key filename varchar(500) filecontent varbinary(max) ) For demo purposes i have set to upload and download one file only. Also i have used Entity framework if you are using stored procedures create a class with the above columns as properties and set the values or directly pass the stored proc content to filename and file content Please dont forget to mark my answer as accepted if it works.