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.

Features

  • 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 and trainer by profession specializing in Microsoft web development technologies. Having embraced the Yoga way of life he is also a meditation teacher and spiritual guide to his students. He is a prolific author and writes regularly about software development and yoga on his websites. He is programming, meditating, writing, and teaching for over 27 years. To know more about his ASP.NET online courses go here. More details about his Kriya and Meditation online course are available here.

Posted On : 27 May 2007


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