vvsharma
03-21-2007, 11:46 AM
Installing the ASP.NET 2.0 Time Tracker Starter Kit
Requirements:
- ASP.NET 2.0
- Visual Web Developer (VWD)
- SQL Express if you intend to develop on your local machine
1) Download and install the starter kit on your computer from http://www.asp.net/downloads/starterkits/default.aspx?tabid=62. Once installed, the Time Tracker Starter Kit should be one of the available templates in VWD
2) Open Visual Web Developer
3) Create a local copy of the site
- Select File -> New -> Website. This should bring up the New Web Site dialogue box.
- Select 'Time Tracker Starter Kit (Language:VB/C#)'
- In Location: Select 'File System'
- Put in a location where you want VWD to install the web site
- Select either Visual Basic or Visual C# as language
- Hit OK
4) Install the Database Schema on DiscountASP.NET SQL server
- Now you have the SQL script file 'timetracker-add.sql' and the database file called 'TimeTracker.mdf' available in /App_code directory of the Project.
- You can use either of them as follows:
(I)To use the former(timetracker-add.sql) to install the Timetracker database schema,do as follows:
osql -S <sql server name> -U <db_user> -P <DB_password> -d <DB_Name> -i <path to the starterKit>\App_data\timetracker-add.sql
(II)To use the later (TimeTracker.mdf) to install the Timetracker database schema (Only for MS SQL 2005),do as follows
a)Copy all the project folders/files to our web server (See KB: http://kb.discountasp.net/article.aspx?id=10364).
b)Goto: 'Control Panel>Datatbase Management>SQL 2005>SQL Tool Suite' and enter a relative path to your applications TimeTracker.mdf (/App_Data/TimeTracker.mdf) in the Attach tool.
c>Click 'Attach MDF file' and once done return to step 5.
5) Once the timetracker database schema is created you need to set up membership / role provider database schema
See KB: http://kb.discountasp.net/article.aspx?id=10413
6) Update the Web.config file
- Comment out the following:
<add name='aspnet_staterKits_TimeTracker' connectionString='Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\TimeTracker.mdf;Integrated Security=True;User Instance=True' providerName='System.Data.SqlClient' />
- Add the following:
<add name='aspnet_staterKits_TimeTracker' connectionString='Data Source=<sql server name>.discountasp.net;Initial Catalog=<DB_Name>;User ID=<db_user>;Password=<DB_password>' />
Also,update
<add name='LocalSqlServer' connectionString='Data Source=.\SQLExpress;Integrated Security=True;AttachDBFilename=|DataDirectory|Time Tracker.mdf;User Instance=true' />
to
<add name='LocalSqlServer' connectionString='Data Source=<sql server name>.discountasp.net;Initial Catalog=<DB_Name>;User ID=<db_user>;Password=<DB_password> />
7) Copy your site to DiscountASP.NET servers (Only if Step 4(II) not followed)
See KB: http://kb.discountasp.net/article.aspx?id=10364
8) Setup the directory as a web application using the Web Application Tool in the control panel.
Vikram
DiscountASP.NET
www.DiscountASP.NET (http://www.discountasp.net/)
Requirements:
- ASP.NET 2.0
- Visual Web Developer (VWD)
- SQL Express if you intend to develop on your local machine
1) Download and install the starter kit on your computer from http://www.asp.net/downloads/starterkits/default.aspx?tabid=62. Once installed, the Time Tracker Starter Kit should be one of the available templates in VWD
2) Open Visual Web Developer
3) Create a local copy of the site
- Select File -> New -> Website. This should bring up the New Web Site dialogue box.
- Select 'Time Tracker Starter Kit (Language:VB/C#)'
- In Location: Select 'File System'
- Put in a location where you want VWD to install the web site
- Select either Visual Basic or Visual C# as language
- Hit OK
4) Install the Database Schema on DiscountASP.NET SQL server
- Now you have the SQL script file 'timetracker-add.sql' and the database file called 'TimeTracker.mdf' available in /App_code directory of the Project.
- You can use either of them as follows:
(I)To use the former(timetracker-add.sql) to install the Timetracker database schema,do as follows:
osql -S <sql server name> -U <db_user> -P <DB_password> -d <DB_Name> -i <path to the starterKit>\App_data\timetracker-add.sql
(II)To use the later (TimeTracker.mdf) to install the Timetracker database schema (Only for MS SQL 2005),do as follows
a)Copy all the project folders/files to our web server (See KB: http://kb.discountasp.net/article.aspx?id=10364).
b)Goto: 'Control Panel>Datatbase Management>SQL 2005>SQL Tool Suite' and enter a relative path to your applications TimeTracker.mdf (/App_Data/TimeTracker.mdf) in the Attach tool.
c>Click 'Attach MDF file' and once done return to step 5.
5) Once the timetracker database schema is created you need to set up membership / role provider database schema
See KB: http://kb.discountasp.net/article.aspx?id=10413
6) Update the Web.config file
- Comment out the following:
<add name='aspnet_staterKits_TimeTracker' connectionString='Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\TimeTracker.mdf;Integrated Security=True;User Instance=True' providerName='System.Data.SqlClient' />
- Add the following:
<add name='aspnet_staterKits_TimeTracker' connectionString='Data Source=<sql server name>.discountasp.net;Initial Catalog=<DB_Name>;User ID=<db_user>;Password=<DB_password>' />
Also,update
<add name='LocalSqlServer' connectionString='Data Source=.\SQLExpress;Integrated Security=True;AttachDBFilename=|DataDirectory|Time Tracker.mdf;User Instance=true' />
to
<add name='LocalSqlServer' connectionString='Data Source=<sql server name>.discountasp.net;Initial Catalog=<DB_Name>;User ID=<db_user>;Password=<DB_password> />
7) Copy your site to DiscountASP.NET servers (Only if Step 4(II) not followed)
See KB: http://kb.discountasp.net/article.aspx?id=10364
8) Setup the directory as a web application using the Web Application Tool in the control panel.
Vikram
DiscountASP.NET
www.DiscountASP.NET (http://www.discountasp.net/)