December 2017 : Online courses in ASP.NET MVC and Angular 4. Conducted by Bipin Joshi. Read more...
Registration for December 2017 batches of ASP.NET MVC / Core and Angular 4 online courses have already started. Conducted by Bipin Joshi. Book your seat 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.

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 a software consultant, an author and a yoga mentor having 22+ years of experience in software development. He also conducts online courses in ASP.NET MVC / 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 Meditation and Mindfulness 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