J
Justincase_2008
Guest
I have a program I wrote that has three columns of text boxes A B and C. The user inputs a Serial number into TextBox A and clicks a button that checks that Serial number against my SQL database. If the Serial number is in the database it will display the Product ID in TextBox B. Then the user clicks a button to update the Product ID to be a good or bad unit and this fills in TextBox C with the new Product ID. there is 15 rows of these text boxes so the user can do up to 15 at a time. Once all the Product IDs have been updated to a good or bad ID the user will click the Apply button which then re writes the database to reflect the new Product ID for those Serial numbers.
As i have found out from testing everything works fine only issue I have is if a user puts in a serial number in Text box A and does NOT click the update ID buttons Text box C is left blank which then will blank out the Product ID in the database when Apply is clicked.
What im hoping to do is write some code that will look at Textbox A and if there is text then make sure TextBox C also has text before the apply command will work. That way if a user forgets to look before they click the apply button i wont have a blanked out product ID.
Im hoping to leave the program open enough so the user can do just 1 Serial number or any amount up to the max of 15.
If anyone has any ideas i would really appreciate the help as this is my first program i have written.
Continue reading...
As i have found out from testing everything works fine only issue I have is if a user puts in a serial number in Text box A and does NOT click the update ID buttons Text box C is left blank which then will blank out the Product ID in the database when Apply is clicked.
What im hoping to do is write some code that will look at Textbox A and if there is text then make sure TextBox C also has text before the apply command will work. That way if a user forgets to look before they click the apply button i wont have a blanked out product ID.
Im hoping to leave the program open enough so the user can do just 1 Serial number or any amount up to the max of 15.
If anyone has any ideas i would really appreciate the help as this is my first program i have written.
Continue reading...