Click here to Skip to main content
13,451,919 members (47,676 online)
Click here to Skip to main content
Add your own
alternative version


67 bookmarked
Posted 20 Aug 2006


, 16 Nov 2009
Rate this:
Please Sign up or sign in to vote.
A simple project task management application. A managed approach to help keep on top of your projects.
Sample Image - maximum width is 600 pixels

Version 3.0

  • Upgraded to SQLExpress datasource
  • Removed references to Interop.Excel
  • Updated Data Access Framework

Technologies and Design Approaches Demonstrated

  • Application offline and online model
  • Authorization to control user access to application features
  • Printing and Print Preview
  • Windows XP Themes
  • Dynamic properties
  • Localization support
  • Accessibility support (limited)
  • Forms authentication using a database for user names/passwords
  • Asynchronous XML service class
  • ADO.NET data access using Microsoft Access SQLExpress 2008 database
  • Graphics development using GDI+
  • Integration between .NET Framework-based code and COM applications (COM interop)
  • The interop assemblies are available from Microsoft as a free download (obsolete)
  • Microsoft Visual Studio 2008

What is the TeamVision Solution?

TeamVision was originally based upon the TaskVision code sample offered via the WindowsForms website. TeamVision is a simple task management application built using the Windows Forms classes of the Microsoft® .NET Framework—an integral Windows® component that supports building and running the next generation of applications. TeamVision allows authenticated users to view, modify, and add projects and tasks that are shared with other users. It may be used in any number of scenarios, from bug tracking to managing work orders or customer service requests. Its primary purpose is to provide quality, sample source code to developers interested in building data-centric applications with ADO.NET using the .NET Framework.

Solution Architecture


All of the shared data is stored in the database. This does not include application specific data or configuration settings. This allows developers to create custom applications, each pulling from a single unique data store. This article provides an overview of the database used in the TeamVision solution.


The TeamVision model schema, is fairly simple, yet ample enough to support this task management solution. Each Concrete Model class derives from a base Model class and must implement at least two properties, PrimaryID and Name.
From there, we get a business class which holds other related class information, and acts as a proxy to that info.

Figure 1 - Model class diagram

Data Managers

The data layer includes Management (Manager) classes that act as an information services wrapper to retrieve and fill all request for data.

Figure 2 - Project Data Manager

Data Access Layer

The DAL provides the functionality for client applications to retrieve and change data, and, with the help of the Data Layer Component, is able to send each request back to a user. The DAL runs in a separate application space which allows for easy changes to the database schema. Every public DAL method is a CLS supported method and allows data to be easily passed within the call.

Using the Code

Figure 3 - Example Load All

Figure 4 - Get by PrimaryID

Figure 5 - Insert example

User Interface

As the Main form handles events such as opening the Search form, the DataLayer object is passed to the new form, providing access to the same data that the Main form is privileged to.

Lessons Learned

TeamVision is a simple solution intended to demonstrate many of the powerful capabilities of smart client applications built using the .NET Framework. Like many projects, TeamVision had its share of growth and opportunities throughout the development phase. However, I hope that through examination of the code you will gain valuable insight in your next development project.


To log-in to the application, use the following credentials:

  • username: "jdoe"
  • password: "welcome"


This article, along with any associated source code and files, is licensed under The Common Public License Version 1.0 (CPL)


About the Author

Terence Wallace
Founder Arkitech EBC Corporation
United States United States
MS, BBA, software developer, consultant, and trainer. Specializing in building data-centric applications designed for business, university, community & faith based organizations. Started developing Excel VBA macros and never looked back. Freelance developer utilizing VB.Net, SQL Server, Microsoft Access, and ASP.Net.

You may also be interested in...

Comments and Discussions

Questioncorrect Username and password Pin
ahamedgad22-Nov-14 10:17
memberahamedgad22-Nov-14 10:17 
QuestionHow can I make my Framework source? Pin
linwenhai14-Oct-14 20:14
memberlinwenhai14-Oct-14 20:14 
AnswerRe: How can I make my Framework source? Pin
TL Wallace17-Oct-14 4:35
memberTL Wallace17-Oct-14 4:35 
AnswerRe: How can I make my Framework source? Pin
Terence Wallace22-Jan-15 8:14
memberTerence Wallace22-Jan-15 8:14 
QuestionUsername & Password ? Pin
maq221-Sep-13 10:10
membermaq221-Sep-13 10:10 
AnswerRe: Username & Password ? Pin
TL Wallace23-Sep-13 15:13
memberTL Wallace23-Sep-13 15:13 
GeneralRe: Username & Password ? Pin
TL Wallace23-Sep-13 15:16
memberTL Wallace23-Sep-13 15:16 
SuggestionRe: Username & Password ? Pin
maq226-Sep-13 10:54
membermaq226-Sep-13 10:54 
GeneralRe: Username & Password ? Pin
TL Wallace2-Oct-13 6:14
memberTL Wallace2-Oct-13 6:14 
AnswerRe: Username & Password ? Pin
ahamedgad22-Nov-14 10:15
memberahamedgad22-Nov-14 10:15 
QuestionI Can Not Open Data Pin
pooyasamaneh29-Oct-12 0:11
memberpooyasamaneh29-Oct-12 0:11 
QuestionHow to setup this project in visual studio ? Pin
thegame4518-Sep-12 19:42
memberthegame4518-Sep-12 19:42 
AnswerRe: How to setup this project in visual studio ? Pin
TL Wallace24-Sep-12 7:27
memberTL Wallace24-Sep-12 7:27 
GeneralUsername and Password Pin
pilly99-Feb-11 11:45
memberpilly99-Feb-11 11:45 
GeneralFor NR Pin
konikula28-Dec-09 13:37
memberkonikula28-Dec-09 13:37 
General[Message Deleted] Pin
konikula20-Dec-09 13:07
memberkonikula20-Dec-09 13:07 
GeneralRe: Nope Pin
TL Wallace20-Dec-09 14:56
memberTL Wallace20-Dec-09 14:56 
Great message. Thank you for your observations. We are all here to help one another become better programmers one way or another. I agree and if I can help out some form or way then don't hesitate to drop me a message or something. Your on the right track. Thanks again.

Happy coding. Smile | :)

"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." - Red Adair

QuestionWhat if you don't have Office 2003 installed? Pin
DJ Matthews2-Jun-09 10:17
memberDJ Matthews2-Jun-09 10:17 
AnswerRe: What if you don't have Office 2003 installed? Pin
TL Wallace2-Jun-09 10:21
memberTL Wallace2-Jun-09 10:21 
GeneralRe: What if you don't have Office 2003 installed? Pin
DJ Matthews3-Jun-09 2:59
memberDJ Matthews3-Jun-09 2:59 
GeneralRe: What if you don't have Office 2003 installed? Pin
DJ Matthews3-Jun-09 5:09
memberDJ Matthews3-Jun-09 5:09 
GeneralRe: What if you don't have Office 2003 installed? Pin
TL Wallace3-Jun-09 5:18
memberTL Wallace3-Jun-09 5:18 
QuestionRelease build? Pin
J.Veurink20-Aug-06 20:25
memberJ.Veurink20-Aug-06 20:25 
GeneralArticle formatting suggestion Pin
The_Mega_ZZTer20-Aug-06 14:24
memberThe_Mega_ZZTer20-Aug-06 14:24 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web01-2016 | 2.8.180318.3 | Last Updated 17 Nov 2009
Article Copyright 2006 by Terence Wallace
Everything else Copyright © CodeProject, 1999-2018
Layout: fixed | fluid