This is an intranet application that allows staff of VDCA(Visakhapatnam District Cricket Association) to enter details of teams, players, matches and statistics of local league matches.

Major Operations

The following are the major operations of this application.

Technologies and Products used

The following table lists operations and associated objects and files.

Operation Files
Login login.aspx
Home Page home.aspx
Adding Team addteam.aspx
Adding Player addplayer.aspx
Adding Match addmatch.aspx, AddMatch Stored Procedure
Adding Batting Details addbatting.aspx
Adding Bowling Details addbowling.aspx
Searching For matches search.aspx
Displaying all matches allmatches.aspx, GetFirstTeam and GetSecondTeam stored functions
Change Password changepassword.aspx
Logout logout.aspx
Default Page default.aspx
Modify Teams modifyteam.aspx
Players of a team teamplayers.aspx
Modifying details of a players of a team modifyplayers.aspx (not included)
Scoreboard of a Match scoreboard.aspx, batting.aspx, bowling.aspx
Creating required Tables tables.txt
Creating ADDMATCH stored procedure addmatch.sql
Creating GETFIRSTTEAM stored function getfirstteam.sql
Creating GETSECONDTEAM stored function getsecondteam.sql
Configuration Details web.config
Pictures related to players JPG files in IMAGES directory.
Web Service all\WSVdca.asmx
Configuration of Web Service all\web.config

The following are the steps to related to be taken to run the existing part of the application :

  1. Download vdca.zip and unzip it into C:\INETPUB\WWWROOT directory (assuming Windows is installed in C drive) li>Connect to SQL Server and create VDCA database as follows:
  2. Make VDCA the current database by giving the following command
  3. Create required tables using TABLES.TXT file and also insert some data into USERS table.
  4. Start IIS and create a virtual directory with the name VDCA and make it refer to physical directory C:\INETPUB\WWWROOT\VDCA
  5. Open Visual Studio.Net 2003 and open the project from C:\INETPUB\WWWROOT\VDCA.
  6. Build the project.
  7. Invoke IE and give the following URL:
    It should display Login Page. Login in with user name and password that inserted into USERS table.