Free Programming Website

Free Programming Website

Tuesday, August 12, 2014

VDCA free project with source codes

VDCA  free project with source codes

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.
  • User logs into site with username and password
  • Adding details of new team
  • Adding details of new player
  • Adding details of a match
  • Adding batting details of a match
  • Adding bowling details of a match
  • Modifying the details of teams
  • Modifying the details of players of a team
  • Allowing user to change password
  • Displaying all matches
  • Displaying the Scoreboard of a match
  • Displaying the details of players of a team.
  • Search for matches
  • Providing Webservice

Technologies and Products used

  • .Net Framework 1.1
  • Visual Studio.Net 2003
  • SQL Server 2000
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 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.