how to upload and retrieve files from database

Question

hi...

i having a upload control from which i will select files.
on insert button click i need to insert these upload files into database
on retrieve button click i should retrieve the files

thanks in advance

Santhosh Kumar Jayaraman · Answer

Hi Bindu 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.