title: Storing, uploading and downloading files in ASP.NET and SQL Server database
body: <p>I have a requirement where I need to upload some PDF files from an ASP.NET page. This upload action is done by admin user. These files which are selected using individual fileupload controls should merge and get stored in a SQL Server database. Now the normal user should be able to login to an asp.net page where a link should be displayed to open the file stored in the database and view it using adobe reader.</p>
  
  <p>I see the following challenges:</p>
  
  <ol>
  <li><p>If I select multiple pdf files, how can I store it in the database in a merged format.</p></li>
  <li><p>Since the file is stored in the database how can I create a link and point the file stored in the database</p></li>
  </ol>
  
  <p>First of all, is this doable. I know about storing a file in a database, but how can I merge and store a file in a database?</p>