April 2018 : Instructor-led Online Courses in ASP.NET MVC / Core and Design Patterns Read more...
Registration open for April 2018 batches of ASP.NET MVC and Design Patterns instructor-led online courses. Conducted by Bipin Joshi on weekends. Register today ! Click here for more details.

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 a software consultant, trainer, author and yoga mentor having 22+ years of experience in software development. He also conducts online courses on ASP.NET MVC, ASP.NET Core and Design Patterns. 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 : Twitter  Facebook  Google+  LinkedIn

Posted On : 27 May 2007

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