You will be continuing to enhance your course project. Data is an important part of many applications, and it is now time to add data connectivity to your application. During this step, you will create a database and connect it to your application in a meaningful way. You will be using SQL Express to create the database and data-bound controls in your ASP.NET application to connect to the data.
Step 1 is to create your database using SQL Express. Visual Studio allows you to create the database directly from within the IDE. Refer back to your original project requirements to create a database that will be appropriate for your application. Be sure to add some sample data to your database. The database may be a single table, or you may want to strive for excellence in the project with a multi-table database with related tables. The second step of the project will be to add data-bound controls to your application to allow you to view and edit the data in the database.
The following are the project deliverables:
Application Design Document
Use MS Word
Title Page
Course number and name
Project name
Student name
Date
Add a "Database Design" section to your design document.
Briefly describe your database.
Provide a diagram showing your database tables and content. This can be an entity relationship diagram or a data dictionary.
Application Updates
Create a database with sample data that you will use for your application. Basic requirements are a single table, and a multi-table database with relations will be regarded as a higher achievement in the assignment.
Add a database connection to your application to connect to your newly created database.
Either modify existing pages or add new pages to your ASP.NET Web application, and use data-bound ASP.NET controls and other necessary controls to perform the following:
View all data in the database in a grid.
View individual records in the database.
Add, delete, and modify records in the database.
Any code necessary for the project should be C# and documented with good comments.