Yes BLOB is just saving data in binary format. You can have column varbinary in your table and you can save your images/files there.
Please see the sample table.
create table uploadtest
(
id int primary key,
filename varchar(500),
filecontent varbinary(max)
)
I have attached a sample working solution for demo purposes in the below thread.
http://www.c-sharpcorner.com/Forums/Thread/179342/how-to-upload-and-retrieve-files-from-database.aspx[
^]
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.
Submit an article or tip