Question on Comparing Data

Question

I am new to vb.net. I have created a form using vb.net. The form has the following fields and a Datagrid: a. Revision b. Installation c. Part No d. Qty e. Description f. Change Rev (Field is Disable - autofill based on criteria) The form also has the command buttons: Save and Close For initial revision - I am able to capture and saved what was key-in the above fields (except Change Rev). For making subsequent revision A (for example) the previous revision data is recaptured onto the fields. However I have a problem. Is it possible when there is any changes made to any of the following field (Part No Qty and Description) that is different from the previous revision the field Change Rev will auto-fill the current revision A in Change Rev. The purpose is to tell the user which set of data is change and in what revision if there is no change make to data the Change Rev remain as . Any advise how to approach the above is appreciated. Thanks

Adam Erstelle · Answer

You could try handling the datatable.rowchanged event. What this will do is if the row has changed in any way it will run the code contained in this event handler. What you could do in here is increment the value of your Current Revision but you will have to be carefull as when you change the value of the current revision this code may run again (as you just changed the data).