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.
Paper#69428 | Written in 18-Jul-2015Price : $37