Included with TEdit 3.0 is a fully functional bug tracking
application, called DXTrack. The source code of DXTrack can be used to learn
best practices for building real-world applications with TEdit.NET.
Source Code
In a default installation, the DXTrack source code and the Visual Studio
2003 project file are installed in the following folder:
C:\Program Files\DVXP\TEdit.NET 3.0\DXTrackVB
The TEdit setup program also creates a virtual directory named
DXTrackDB in Internet Information Server (IIS) that maps to this
folder. Therefore, you access the DXTrack sample from your local workstation by
the URL
http://localhost/DxTrackVB.
Database Configuration
DXTrack uses a SQL Server 2000 database.
Before you can start using DXTrack, this database needs to be attached to your
SQL Server. To do so, follow the following steps.
Attach the database
Open SQL Server Enterprise manager, click on the Databases node, and choose All
Tasks, Attach Database from the context menu.
Attach the DXTrack.MDF file that is installed in the folder
C:\Program Files\DVXP\TEdit.NET 3.0\DXTrackVB\SqlData.
Configure integrated security
If the DXTrack web site and the SQL Server are running on the same computer,
you can use Integrated Security to provide access to the database to the
ASP.NET user account that runs the web site.
If you don't use integrated security, you need to change the connection string
that is specified in the web.config file, located in the DXTrack folder in
order to use a SQL server account, such as 'sa'. See
http://www.connectionstrings.com for instructions on how to edit
connection strings.
In order to configure the DXTrack database for integrated security, a login
must be created for the ASPNET user account. Click New Login from the context
menu of the Security Logins node in Enterprise Manager.
Select the local computer name as the Domain, and enter the ASPNET user
account.
Go to the Roles tab-page, and grant the ASPNET account the db_owner role to the
DXTrack database.
Test the configuration by opening the
http://localhost/DxTrackVB
web site, and click the Create Account link.