Question
This Homework tests your skills on implementing a database in Visual studio. Start early, finish early and you wont have to ask me for any
This Homework tests your skills on implementing a database in Visual studio. Start early, finish early and you wont have to ask me for any extensions. In this HW you are going to develop a database application that will show the Top 500 Rock and Roll Songs. Here is what you are going to do (I left out some of the details for you to figure out): Read the whole document a couple of times to let it sink - Attached is a text file that contains titles of songs. The file contains 500 lines. Each line has o Rank of song o Artist o Song Title - Create a Windows application - Add a new Service based database to your project. - Create a table in this database, call it songs. The table should have four columns SongID (int, primary key), Rank of song (int), artist (nvarchar(50)), and song title (nvarchar(50)). - Link this table to your application using Add New data source - Add a grid view of the table to your application and run the program to check if it is working - By now the table is empty. The next step is to fill it out using the data in the text file. - Open the file and read each line. Tokenize the line to extract rank, artist, and song title. - Open the xsd file and create a new Insert Query that will add records into the table - For each line you read from the text file you should use the SQL insert command (via a method) to create a new record in the table - You should provide a search box that returns all rows that match the name of a certain artist using query parameters (hint: use LIKE operator) - You should also provide a button to show all items (records) Your program interface is simple containing: 1- A data grid view: should be empty at the start of the program 2- An import button: import data from text file and populates the grid view (DB) 3- A search textArea and a search button: to return rows that match an artist 4- A show all items button: shows the full 500 records 5- An exit button: exits the program
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started