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

Academic Project - Address Book (dot net source code)

This is a small C# project submitted by one of our members.

This is a small project for managing personal contact details. You can add, edit, and delete contacts and addresses.

A data grid displays all available contacts. You can select any contact in the grid and press the 'Edit' button to edit the details. When the 'Edit' button is pressed, all fields will become editable. After completing 'Editing', press the 'Save' button to save the details to database.

The 'Delete' button will set a status field in the record to 'Deleted'. Only records which are not marked as 'Deleted' will be displayed in the grid. (Note that we never delete a record permanently from database. We are only setting a field to the value 'Deleted'.)

Download the source code and enjoy learning .NET.

DOWNLOAD SOURCE CODE
5-121553--addressbook_csharp.zip (5--121553--addressbook_csharp.zip)
5-121553--addressbook_csharp_demo.zip (5--121553--addressbook_csharp_demo

School Management System (source code) project

This is a medium sized project for managing educational institutes. Current version of this project includes Student Management System, some forms for managing Staff, Batches etc. We are continuously working on this project and we will update the latest versions when available.

This is an ideal project for MCA and Engineering students who want to do academic project using C#. You can download the source code and use this as a template. Even though we have implemented many features, you can extend it by adding several new features to it.
Feel free to write to us if you have any questions or if you have suggestions for improvement.

Upcoming features include 'Marks', 'Attendance', 'Librabry Management' and more...

Project Architecture

For simplicity and to make it easy to understand, we have not used any complex design patterns. This is a beginners project and is provided with the intention of helping students understand and learn C# and .NET.

MS Access is used as the database back end. We haven't tested this with SQL Server, but probably it should work without any changes.

For each database table, we have used a corresponding class (entity class). For example, we have tables called 'Student', 'Batch', 'Staff' etc. For each table, we have matching classes called 'Student', 'Batch', 'Staff' etc. The fields for each class matches the fields in the table.

For each entity class, we have a manager class. For example, for the 'Student' class, there is another class called 'StudentManager'. For the class 'Batch', there is a 'BatchManager' class. The manager class has methods like CreateStudent, UpdateStudent etc. These methods are used to create and update the entities in database.

We have tried to use Object oriented programming as much as possible. So, all database operations operatiosn are performed through classes. The manager classes are used throughout the program to create and update records.

The standard approach we follow for each entity is, all entities are displayed using a datagrid. When we select a record in the grid, the fields of the selected entity is displayed in the fields in details area. The fields will be editable only when the 'Add' or 'Edit' button is pressed.

Delete option - We will not delete any record permanently. We will only set the status field as 'Deleted'. The grid will show only records which are not marked as 'Deleted'.

If you experience any difficulty in understanding the project, please use the feedback form below and we will clarify your doubts.

Known Issues

The date fields are not working as expected. Shows wrogn results in UI and also updates wrogn results in database. Will be solved soon.
The classes used are not inside any namespaces. Need to include them in namespace.

Please use the feedback form below, if you come across any other issues.

Download the source code and enjoy learning .NET.

SOURCE CODE DOWNLOAD
6-121557--sms.zip (6--121557--sms.zip)
6-121558--sms_demo.zip (6--121558--sms_demo.zip)

Library Management System(dotnet tutorial)

A simple library management system that provides following facilities login, register, add category, add / remove book, search / issue book, return book. Language used is C# and db is SQL server 2000 and SQL Client has been used in code.

One Admin user is already there once db is installed with user name admin and password admin.

Admin user has extra functionalities like add category, add/remove books. These functionalities can not be done by simple user that registers.

Password encyption - decryption has been used in project. Its very simple project where in all the events of all forms has been handled in Globals.cs that acts as business and data access layer. All DB interactions are in this file only.

As far as db is concerned there are only 4 tables
1. Lib_Users - fields are User_ID,User_Name,User_Password,User_Is_System,User_Created_Date,
Number_Of_Books_Issued

2. Lib_Book_Details - fields are Lib_Book_ID, Lib_Book_Title, Lib_Book_Category,
Lib_Book_Author_Name ,Lib_Book_Issue_Status, Lib_Book_In_Inventory

3. Lib_Book_Issue_Details - fields are Lib_Book_Issue_ID, Lib_Book_ID, Lib_Book_Issued_On,
Lib_Book_Issued_To, Lib_Book_Returned_On

4. Lib_Book_Categories - fields are Category_ID, Category_Name

Screen shots are in word doc Library. Read instructions.txt to install the code.

Architecture is pretty simple as project is very simple. All forms have events and all events needs are sufficed from Globals.cs that is one single point access to DB.

I am working on this to add more features. This will be done soon.

Files Uploaded are - LibraryManagementCode.zip (contains code)
Debug.zip - contains exe
Instructions.txt
library.txt - SQL file
Library.doc - all screen shots

download 3-1584-library.zip, inside it .sql file is present

DOWNLOAD SOUCE CODE
3-15040-LibraryManagementCode.zip (3-15040-LibraryManagementCode.zip)
3-15040-Debug.zip (3-15040-Debug.zip)
3-15041-Library.doc (3-15041-Library.doc)
3-15041-library.sql (3-15041-library.sql)
3-15042-Instructions.txt (3-15042-Instructions.txt)
3-1584-library.zip (3-1584-library.zip)