Developer's Guide to ASP.NET 3.5 Master ASP.NET 3.5 development using C# and Visual Studio.NET 2008. Web forms, server controls, data binding, AJAX, ASMX and WCF services and more...

Kriya Yoga for Software Developers Importance of concentration, confidence, positive attitude, better personality and stress free life need not be emphasized separately in today's competitive world...

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

Current Rating :
Rate This Article :	5 - Excellent 4 - Very Good 3 - Good 2 - Average 1 - Poor

About the Author

Bipin Joshi Bipin Joshi is the proprietor of BinaryIntellect Consulting where he conducts premier training programs on .NET technologies. He wears many hats including software consultant, mentor, prolific author, webmaster, Microsoft MVP and member of ASPInsiders. Having adopted Yoga way of life Bipin also teaches Kriya Yoga to the interested individuals. His detailed profile can be read at his blog. He can also be reached there.

Comments

Congratulations Excellent article, congratulations. To register in cadastre the archive you can use the FileBytes property. if (FileUpload1.HasFile) { filesize = FileUpload1.PostedFile.ContentLength; byte[] filedata = FileUpload1.FileBytes; //Property FileBytes Files.Create(filename, filedata, filesize, folderid, DateTime.Now); } Fabio Mans Posted By : Fabio Galante Mans Posted On : 6/7/2007

Re Run the TSQL.sql file in SQL Server Management studio so as to create database tables and stored procedures Dear Bipin, Can you tell how do we run the TSQL file in SQL Server Management studio.I am not aware of SQL Server Management studio at all. (you are to tell where is it, and how do i run any query in it etc..) Posted By : Neeraj Posted On : 7/14/2007

Re: Re Run the TSQL.sql file in SQL Server Management studio so as to create database tables and stored procedures Open SQL Server Management Studio from Start menu. While opening it will ask for db user id and pwd. Then expand Databases node and to see your databases. On the top there is a toolbar icon called New Query. Click on it to open a new query window. Copy paste the TSQL script in the window and press F5. Posted By : Bipin Joshi Posted On : 7/16/2007

Not very good package Downloaded your Starter Kit and I had to go and download 38.5mb of data to allow your starter kit to run. When I try to connect to SQL server it does but has problems for login. It would be better if everything was read instead of having to do it when you got it. Also if you can use Install Creator or somthing to make an installer package. If would be very happy if you could give me a copy of it all-ready extracted so it's read to run... I'm sure it's possible. If you can make a website, you can do what I just asked. -- Edited by moderator to protect poster's email address -- Any help? Please email! Posted By : Alan Doherty Posted On : 11/1/2007

Re: Not very good package Alen, You must be missing something. The download of this sample application is just 544 KB and not 38.5 MB as you are claiming. You can read the two PDF files included in the download to know everything about this application. Posted By : Shiva Posted On : 11/2/2007

thank you your source code is very useful Posted By : basheer Posted On : 1/9/2008

SQL Server Hi Very interesting pacakge. I could not get it to run on SQL server as I get an Incorrect Syntax error on this line WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY], Regards, Posted By : David Harloms Posted On : 2/4/2008

Re: SQL Server Are u using SQL 2005? The system requirements say that it needs 2005. Posted By : Shiva Posted On : 2/5/2008

Thank you (Bipin Joshi and his team) Many Many Congratulation! You do very excellent work. It is like boon for the beginner as well as experienced programmer. All of us are very greatful to you. Once again thank u very much. Posted By : UDAY SHUKLA Posted On : 4/4/2008