The ProjectPal Database

Let’s get our hands a little dirtier by looking at the data, code, and techniques used to create the ProjectPal system.

Not all the code in the ProjectPal system is here because of space constraints and the fact that some of the code is quite repetitive. However, you can download the full source code, as mentioned at the beginning of this chapter, or play with it online at

The ProjectPal system uses SQL Server 2000 as its main datasource. The system is made up of various tables, views, and stored procedures. Throughout this section, I assume you have knowledge of SQL Server, SQL Queries, and basic Transact SQL.

Database Schema

The Database schema used by the ProjectPal system is ...

Get Inside ASP.NET now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.