I have already explained how to save and retrieve files in SQL Server database using ASP.Net in my article This article is an extension of the same since was frequently asked on how to save file directly to database using the ASP.Net FileUpload Control You can upload any files like images, Word document. Excel document, Portable Document Format (PDF), Text Files sand save them to Database Database Design Here I have created a Database called dbFiles and it has a table called tblFiles. It has 4 Fields. The complete description is available in the Figure below As you can see above for the id field I have set Identity Specification true, so that it automatically increments itself. Field Relevance id Identification Number Name File Name Content Type Content Type for the file Data File stored as Binary Data Connection String Below is the connection string to the database.

You can modify it to suit yours.

Save Files to SQL Server Database using FileUpload. Word document. Excel document, Portable Document Format (PDF. ASP.Net ListBox: Save Multiple Selected Items. Now I will upload 3 files of various types like Word, PDF and Excel files one by one using the following procedure: Fill in the Display name and click on the browse button to select the file. After selecting the file.

This will ensure that changes to the database are saved at the end. Build the project and run it. When the form is displayed, click the 'Add new' button. An 'open file' dialog will be displayed. Select a PDF file and press OK. The PDF file will be added to the database, and then displayed in the viewer. Here Mudassar Ahmed Khan has explained how to upload and save PDF files to SQL Server Database table using File Upload control and then retrieve and display the PDF.