I want a C# program that will update some information in a database and validate that the new information is correct. The program should have a text box (that only excepts numbers) and a Load button. When load is pressed the program should "SELECT * FROM Items_Packed WHERE Invoice_Number = [at]numberFromLoadBox", "SELECT * FROM items WHERE inv_id = [at]numberFromLoadBox", then "UPDATE Items_Packed SET Items_in_Box = NULL WHERE Invoice_Number = [at]numberFromLoadBox" Below the Load button there is a listBox and a Grid with and Add button between them. The Boxes grid should be on the right and have the columns "Box #", "Items in box", Edit, and Delete The "Box #" is the ID from the Items_Packed table. The "Items in box" is the Items_in_Box from the Items_packed table. The Edit column has an Edit button for each box. The Delete column has a delete button for each box. The Items listBox is on the right and has all items (sku from items table) that are not packed in a box yet (Items_in_Box from the Items_Packed table) The boxes table is READ ONLY except for the the buttons being allowed to be pushed. The Edit button removes the items from the box (which adds them to the items listBox). The Delete button removes the items from the box (which adds them to the items listBox) and makes the row have a different background color to indicate that the box is deleted. It also changes the delete button from saying delete to saying UnDelete. If the UnDelete button is pressed then the row goes back to being normal and the UnDelete button is changed back to a Delete button. The items are NOT put back in the box. Continued in attached text file as the description is over the RAC length limit...
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).
C#, Compiles in VS 2005