Web based Address Book (SOURCE CODE)

Web based Address Book

Murali Krishnan has posted an excellent learning project. This is a web based, address book application developed using ASP.NET and C#. SQL Server is used as database back end and stored procedures are used for database retrieval and updates. This is a good startup project for beginners who want to learn mutli tier application development.

How to use the sample application ?

You can download the sample web application by clicking on the above link. Download the zip file and extract. Right click on the folder 'aspdotnet' and select 'Properties'. Select the tab 'Web Sharing'. Choose the option 'Share this folder'. This will make it a virtual folder.

Now you have to create the database. Open the SQL Server Enterprise manager and create a new database with the name 'Contacts'. Now run the script 'ContactInfo_CRM.sql' in this database. This will create the required tables and stored procedures.

Now you are ready to go! Double click on the solution file 'aspdotnet.sln'. This will open the solution in VS.NET. Open the web.config from the Visual Studio project. Edit the following key :



Edit the uid and pwd fields to use the correct user id and password in your database.

Compile and run the project. You will see the web based address book application opened in Internet Explorer.

Highlights

Tier based design approach
Usage of components
Stored Procedures for database activities

Datbase Tables

ContactInfo

Stored Procedures

ContactInfo_Insert
ContactInfo_Update
ContactInfo_Delete
ContactInfo_GetContact
ContactInfo_GetContactList

DOWNLOAD SOURCE CODE
10-121638-Contacts.zip (10-121638-Contacts.zip)


10-121644-ContactInfo_Edit.jpg


10-121644-ContactInfo_List.jpg