Store documents in on-line briefcase

Web sites often store files directly in some folder of the file system. However, this may not be the most suitable way in all scenarios. Many of you might have used Yahoo Briefcase. It allows you to store any file on the server so that you can access it from anywhere. If you wish to provide such a facility in your web site then file system based storage and retrieval is tedious. Enforcing security and managing storage space quota becomes difficult. More elegant solution can be developed by storing files in database. This way you have full control on who is storing and retrieving files, storage space and usage statistics.


  • The application should allow to manage files and folders via a web based interface
  • The application should allow us to create folders and sub folders
  • There should not be any limitation on the nesting levels of the folders
  • The application should allow us to delete and rename the folders
  • The application should allow us to upload files to a specific folder
  • The file can be downloaded at any time by navigating to that folder
  • We should be able to delete or rename the file
  • The creation date and size of the file must be tracked
  • If a folder is deleted then its subfolders and files should also be deleted
  • Just like file system the application must ensure that there are no duplicate file or folder names in a given scope

System Requirements

  • .NET Framework 2.0
  • SQL Server 2005 (Express will do)
  • Visual Studio 2005 or Visual Web Developer

Installation Instructions

  • Download the associated ZIP file
  • Unzip in a folder
  • Run the TSQL.sql file in SQL Server Management studio so as to create database tables and stored procedures
  • Open the folder in Visual Studio (or VWD) using File - Open Web Site menu option
  • Change database connection string in web.config
  • Run the web site

Screen Shot

Bipin Joshi is an independent software consultant, trainer, author, and meditation teacher. He has been programming, meditating, and teaching for 25+ years. He conducts instructor-led online training courses in ASP.NET family of technologies for individuals and small groups. He is a published author and has authored or co-authored books for Apress and Wrox press. Having embraced the Yoga way of life he also teaches Ajapa Yoga to interested individuals. To know more about him click here.

Get connected : Facebook  Twitter  LinkedIn  YouTube

Posted On : 27 May 2007

Tags : ASP.NET Data Access ADO.NET Sample Applications Projects