Learn ASP.NET Core and Design Patterns with Real-World Examples. Instructor-led online courses. Read more...
Live instructor-led online courses in ASP.NET Core and Design Patterns. Registration is open for November 2018 batch. More details are available here.

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, trainer, author and spiritual yoga mentor having 23+ years of experience in software development. He teaches online training courses in ASP.NET Core, Angular, and Design Patterns to 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 : Twitter  Facebook  Google+  LinkedIn

Posted On : 27 May 2007


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