This project requires you to create a solution that utilizes a menu to locate, add, change and delete records from a database table. The figure in the attached zip file shows the complete form for the solution at runtime. Create the forms user interface with the necessary lables and text boxes to display the fields from the underlying table. Create a main menu for the form. Create a menu title having a menu item named Exit to exit the solution. On the Edit menu, create menu items to add, edit and cancel editing of the current record, and to update and delete database records. On the Navigate Menu, create menu items to locate the first, previous, next and last record in the database table. Using the Data tab on the Toolbox, create an instance of the OleDbConnection control, and configure it so that you establish a connection with the database named [url removed, login to view], setting the drive designation as necessary. Generate the DataSet for the DataAdapter you just created. Set the DataSet name to dsParts. Write the necessary code to bind the fields in the underlying DataSet to the text boxes you just created. Perform this task when the form loads. Create the code for the add, edit, upate, cancel and delete menu items. So that the user cannot add or delete a record while the current record is being edited, create a subprocedure named EditState to enable and disable menu items as necessary. Enable or disable the text boxes also. Your solution should calculate the gross profit for the current item by subtracting the cost from the sales price. The total inventory at cost is calculated by multiplying the cost by the quantity at hand. You should display these output values whenever tile user locates a different record or updates a record. I-lint: Create a sub procedure and call that procedure from the navigation menu items. See attached zip file for more details.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables):
a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
Windows 2000, Windows XP, Visual Basic .NET