Analysis of a CD Catalogue Website in ASP.NET - Project Report

This report presents a comprehensive overview of a CD catalogue website developed using ASP.NET and SQL Server. The website features a user-friendly interface for browsing and searching CDs by genre, along with an administrator section for managing the CD database. The user section allows users to view a complete collection of CDs and search for specific genres. The administrator section enables administrators to add, edit, and delete CD details, including genre, album name, artist, and release year. The report outlines the website's structure, including the use of master pages and user controls for a consistent layout. The solution provides a functional prototype, highlighting the potential for further development and enhancements. The report details the database structure, user login functionalities, and the integration of SQL Server to manage CD information effectively. This project provides a practical example of web application development using ASP.NET and SQL Server, addressing both front-end user interaction and back-end data management.

Running head: COLLETZ: CD CATALOGUE WEBSITE IN ASP.NET
Colletz: CD catalogue Website in ASP.NET
Name of the Student
Name of the University
Authors note

1COLLETZ: CD CATALOGUE WEBSITE IN ASP.NET
Introduction
The “Collectz” is a CD catalogue site for the simple users who can explore the
complete database of the CD’s and also search for a specific genre of song. The site is
developed using the ASP.NET (For Front end) and SQL server (for Back end database). This
report contributes to the discussion on various features of the developed Website. In addition
to the that, the way users interact with different features of this site is also provided. Some of
the features are related to the backend database (mainly for the administrators). Other features
are used by the users who will try to get the details of the CD’s at the front end.
User section
The website has a login page for the users after which the users will be able to view
complete collection of the CD available in the database. On the login page there is a
hyperlink for that leads to the admin login page which is only intended for the administrators
of the website and is discussed in brief in the next section.
In order to manage the user details, CD details to store the related data we have used
the SQL server database. Using this SQLSERVER database we have created the required
database.
Following is the CD collection section that will be displayed when the user will get
logged in their account. On this page the user will be able to search for a specific song genre
by using the drop down list control on the page.

2COLLETZ: CD CATALOGUE WEBSITE IN ASP.NET
Following is the sample screen shot for the search of rock genre songs from the
database.

3COLLETZ: CD CATALOGUE WEBSITE IN ASP.NET
Administrator section
For the administrator section we have provided a hyperlink for the users to login as a
administrator with the username “admin” and the password=123456. When they login in the
account they will see the complete catalogue of the available CD in the database. In the
displayed grid view of the CD’s the users will be able to update the details of any CD or
delete from controls provided in the tables.
On the admin section, administrator can add a new CD details by selecting the Genre,
and other details like artists, cover image of the CD and the release year of the CD on the
Add new record page.
As shown in the following screen shot, the administrator will be able edit any details
of the selected CD. Such as Genre, Album_name, Artsist, ReleaseYear.

4COLLETZ: CD CATALOGUE WEBSITE IN ASP.NET
As shown on the above screen shot the admin can also search for a specific song
genre so that they can edit the songs of that genre.
Conclusion
As this is a prototype solution for the actual website thus it can be said that there are
many features can be added to make the website more attractive. However, we have provided
the consistent layout to all the pages by using the master pages for this ASP.NET project and
other user controls on the pages.