visual basic programming

the product.sql file will be conneceted with the following program and it will have some products that can be updated by the app

Using the typed datasets disconnected model, design the following application to update a record in the table. The application should meet the following requirements:

The Item numbers should be automatically populated into the combo box when the form is loaded. The values are derived from the ItemNum field of the tblProducts table.

The category and supplier combo boxes should also be dynamically filled up. Ensure that there are NO duplications of values in these boxes.

When the user selects an item number from the combo box, the remaining fields should be automatically filled up.

The user should be able to update all values other than the item number. Write code for the update button to complete the task.

The price and quantity in stock items should be positive numbers. If user enters a negative number, an error message should be displayed.

All the fields are required fields; if the user does not enter a value then an appropriate message should be displayed.

Only typed dataset disconnected model should be used, no points will be awarded if any other model is used for answering this question.