Hockey League

Create a web application that displays the hockey league statistics.

 You need to create a SQL Server database as a MDF file.

 Then download the [login to view URL] file from SLATE, and run the SQL queries

in Visual Studio to create the database tables.

 There are two tables:

i. Player

ii. Statistic

 The PlayerId column of the Player table is a foreign key in Statistic table.

3. The application should have three webforms, derived from a master page:

 Home | Add Player | Add Stats

4. Refer to the images at the end of this document to get some hints.

 Your pages do not need to look similar to my design.

 Use you own imagination to design and style the pages.

 However, all the required information, as seen in the screenshots below, must be displayed.

Home WebForm:

1. This webform has:

 GridView: to display the player stats.

 Labels: to display the players with lowest points and highest points.

2. On the initial page load, fetch and display the player stats in the GridView.

 Use INNER JOIN to print player names along with their stats.

 Do not print ID columns.

3. Find players with the lowest and highest points, and display their names along with the points,

somewhere underneath the GridView.

Add Player WebForm:

1. This webform has:

 Two TextBoxes: to type the player’s name and jersey number.

 Button: to add the player’s information to the database.

 RequiredValidationControls: to add the validations.

2. This webform adds the player’s name and jersey number to the database table.

3. Add validation controls so that the text fields cannot be left blank.

Page 2 of 7

Add Stats WebForm:

1. This webform has:

 DropDownList: to display player names.

 Four TextBoxes: to enter the matches played, won, assists and goals.

 Button: to add the above information to the database.

 Validation Controls: to handle any validations that may occur.

2. On the initial page load, the player DropDownList is filled with their names, along with the first

item as “Select player”.

3. Then the user can enter the other data in the textboxes.

4. Before adding the data to the database table, calculate the player’s points.

 Assist is 1 point each and goal is 2 points each.

5. No field could be left blank or unselected.

 Add the necessary validation controls.

App Design:

1. Use a master page to design the layout of the application.

 Your application should have a header that displays the website title. Add a background

image to the header.

 A navigation bar, either under the header, or in a sidebar having these links:

i. Home | Add Player | Add Stats

 A main content section that will change its content from page to page.

 A footer that display’s your name and student ID.

2. Give proper names to all the ASP.NET server controls.

3. Create all your webforms using the master page.

4. There should be no compile-time errors or run-time exceptions in your application

Habilidades: .NET, Programação C#, Microsoft SQL Server , MySQL, SQL

Veja mais: user select delphi, set textboxes user interface cnet project setup, hockey league script, nhl playoffs, junior hockey leagues, nhl teams, southern professional hockey league, live hockey stats, hockey leagues ranked, federal hockey league, ice hockey league, vbscript user select text file, hockey league logo creator, allow user select picture java, allow user select date calendar javascript, user select unselect categories display wordpress, a2billing user select call plan prefix, bus reservation system user make reservation eventually pay ticketresult reservation record created user select seatmodels buses, free php hockey league, hockey league management

Acerca do Empregador:
( 1 comentário ) Brampton, Canada

ID do Projeto: #19073124

4 freelancers estão ofertando em média $54 para esse trabalho


Hi, when is the deadline of this assignment? have you got all files required to send me. i will also explain you for understandng if you need and help you

$25 CAD em 1 dia
(72 Comentários)

Hi Glad to see you I am senior web developer with 8 years of full stack experience I am good at ASP.NET web app development with MsSQL, MySQL Please ping me without hesitation Thanks Regards

$25 CAD em 1 dia
(11 Comentários)

Hi there My name is Carlos and I'm an expert in .Net and sql server. I have been working in software developement for the last 20 years. I have many experience in desktop and web development. Regards

$66 CAD in 2 dias
(28 Comentários)

Hi Sir, Ready to build hockey league statistics website for you according to your requirements. Please check some of our Creative work [login to view URL] [login to view URL] https://reactivesp Mais

$100 CAD em 1 dia
(16 Comentários)