An Untyped DataSet Application
VB.NET Programming
Need Answer ASAP Please
You will develop SmartInventory v2.0 using an untyped DataSet application using a BindingNavigator control and a BindingSource object (100 Points + 20 Bonus Points) Database File: You can use your own database designed for Homework 3. Make sure that there are no special characters in your table/attribute names. Do not use any Microsoft Access reserved words (https://support.office.com/en-us/article/Access-2007-reserved-words-and- symbols-e33eb3a9-8baa-4335-9f57-da237c63eabe). (1) User interface design: Design a Windows Form, as the one shown below, to browse and modify existing replenish orders. You need to use a BindingNavigator control to browse and modify the order records cached in an untyped DataSet. You also need to add a "Save" Button on the BindingNavigator control, which is used to commit permanent changes in the database. You can find the disk icon file (disk.ico) in the SilkIcons library. (20 points) SmartInventory v2.0 O of {0} Do x + XB Device ID Supplier ID Order Date Order Type Quantity Order Status (2) Programming: Use a DataReader object to populate all existing device ids from the device database table into DeviceComboBox. The StatusComboBox should be populated at the design time with three items: PENDING, COMPLETED, CANCELLED. (20 points) (3) Programming: Create a DataSet that is used to cache existing replenish order records retrieved from the database. (20 points) (4) Programming: Use a BindingNavigator control to browse, add, modify, or delete replenish order records cached in the DataSet. You must use a BindingSource control/object to link the Windows controls to your Data Table object. (20 points) (5) Programming: By clicking the "Save" ToolStrip Button on the BindingNavigator control, the changes made to the DataSet will be saved to the database. Your program should check if the changes have been successfully saved to the database and prompt the user with a message. (20 points) (6) Bonus question: (20 points) A DataTable object can be queried just like a relational database table. For example, the Compute() method can be used to calculate an aggregate function against the records in a DataTable. The following statement is an example that counts the number of "Yes" votes in the voting records cached in a congressDataSet object (BillNumber is an attribute in the Voting Records table): Dim numOfYesVotes As Integer = congressDataSet. Tables(VotingRecords).Compute("count(BillNumber), "BillNumber='H.R.1.1' AND Vote='Yes") Add a Label control and a TextBox control at the bottom of the Form. The Label control should display "Total quantity in pending order". The TextBox control is used to display the sum of the quantities in the pending orders for the selected device. You will develop SmartInventory v2.0 using an untyped DataSet application using a BindingNavigator control and a BindingSource object (100 Points + 20 Bonus Points) Database File: You can use your own database designed for Homework 3. Make sure that there are no special characters in your table/attribute names. Do not use any Microsoft Access reserved words (https://support.office.com/en-us/article/Access-2007-reserved-words-and- symbols-e33eb3a9-8baa-4335-9f57-da237c63eabe). (1) User interface design: Design a Windows Form, as the one shown below, to browse and modify existing replenish orders. You need to use a BindingNavigator control to browse and modify the order records cached in an untyped DataSet. You also need to add a "Save" Button on the BindingNavigator control, which is used to commit permanent changes in the database. You can find the disk icon file (disk.ico) in the SilkIcons library. (20 points) SmartInventory v2.0 O of {0} Do x + XB Device ID Supplier ID Order Date Order Type Quantity Order Status (2) Programming: Use a DataReader object to populate all existing device ids from the device database table into DeviceComboBox. The StatusComboBox should be populated at the design time with three items: PENDING, COMPLETED, CANCELLED. (20 points) (3) Programming: Create a DataSet that is used to cache existing replenish order records retrieved from the database. (20 points) (4) Programming: Use a BindingNavigator control to browse, add, modify, or delete replenish order records cached in the DataSet. You must use a BindingSource control/object to link the Windows controls to your Data Table object. (20 points) (5) Programming: By clicking the "Save" ToolStrip Button on the BindingNavigator control, the changes made to the DataSet will be saved to the database. Your program should check if the changes have been successfully saved to the database and prompt the user with a message. (20 points) (6) Bonus question: (20 points) A DataTable object can be queried just like a relational database table. For example, the Compute() method can be used to calculate an aggregate function against the records in a DataTable. The following statement is an example that counts the number of "Yes" votes in the voting records cached in a congressDataSet object (BillNumber is an attribute in the Voting Records table): Dim numOfYesVotes As Integer = congressDataSet. Tables(VotingRecords).Compute("count(BillNumber), "BillNumber='H.R.1.1' AND Vote='Yes") Add a Label control and a TextBox control at the bottom of the Form. The Label control should display "Total quantity in pending order". The TextBox control is used to display the sum of the quantities in the pending orders for the selected device
