Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Database Management Systems

Authors: Mark L. Gillenson

2nd Edition

0470624701, 978-0470624708

More Books

Students also viewed these Databases questions