Database Connectivity Using ADO.NET In the previous assignments, you have used simple text files for data about the courses available for registration and for which the user is registered. In the real...

1 answer below »
Database Connectivity Using ADO.NET
In the previous assignments, you have used simple text files for data about the courses available for registration and for which the user is registered. In the real world, such data is kept in a database. For this assignment, you will revise your registration application so that it uses a local SQL Server database.
Confirm that SQL Server is running on your local computer by connecting to it using SQL Server Management Studio.
Download the cf_u06a1_SQL_Schema.ZIP file and unzip it. Open the u06a1.sql file in SQL Server Management Studio and run the file to create the database, tables, application user account, and load the initial data.
Using your Visual Studio solution for U04a1 as a foundation, add the necessary data sources to the application and revise the event handler code so that the program reads and writes data from the database rather than using text files for the data.
Assignment RequirementsBe sure to do the following:
Write a syntactically correct C# console program that compiles and runs without warnings or errors.
Use the previously designed Course class library in your WPF application.
Complete the design of the user interface so it uses appropriate controls for listing available and registered courses and providing responses to user selections.
Implement event handlers for user-interface controls.
Answered 1 days AfterMay 15, 2022

Answer To: Database Connectivity Using ADO.NET In the previous assignments, you have used simple text files for...

Raja answered on May 17 2022
89 Votes
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here