POS 409 Week 5 Database Application
Build a SQL Server database in your Visual Studio project. Add a table in the database using the properties of the classes you defined in Week Four as your fields. Populate the table with at least five records. The table can be manually populated within Visual Studio instead of populated in a programmatic manner.
Design, implement, test, and debug a C# program to access the database and display the entries in a DataGridView. As with prior weeks, remember to utilize the concepts described in the weekly reading to complete the project. The type of application to be developed is a Windows Forms application.
Use SQL to create two queries in the table adapter on the form. For the first query, sort the data in the DataGridView by one of the fields in the table. Create a button on the form to execute the query to sort the data. For the second query, use one of the fields on the form in a Where clause to only display a subset of data in the DataGridView. For example, if one of the fields in the table is QuantityOnHand, you could have the query display only records where QuantityOnHand is greater than a particular amount. Create another button on the form to execute the query to display a subset of the data using the second query.
Include identifying information in the form of block comments at the top of each class in the project (programmer name, date, program description). Include adequate comments throughout the program, utilize meaningful names for controls, variables, fields, and forms. Include white space for readability purposes in the code. The focus of the project is on learning the C#.Net syntax. However, ensure the form is simple and easy to understand for the user. Refer to the Individual Assignment grading form to view grading criteria.
Zip the files of the project together and submit the zipped file. Include the database in your zip file also.