I'm working in vb.NET. My program will be updating databases. However, the user does not want the program to make changes to the database until the user is ready to close the program. At which time, the user would like a short summary explaining all of the changes he/she has made to the dataset. I know I can use .haschanges() to discover if the user has made changes, but is there some way to be able to describe exactly what the user has changed (i.e. the information in the fields of a row the user has altered)? I'm not even sure something exists, so just a few ideas to get me heading in a direction would be nice.
-
-
Well if its not going to be a huge dataset, you could keep two copies of it. One as the "original" and another as the one that gets changed.
Then when the time arises, just go down and compare the two of them and display the differences to the user? -
Its standard when working with datasets to have them disconnected, make changes and then update. You are right about haschanges, but you may also be able to use dataset.getchan ges to achieve what you want. HTH.Originally posted by SenileOwlComment
-
I know this is late and probably no one will care, but thanks for your help. I ended up getting new marching orders and took it a different route. I will be creating a table to store the data that I want about the changes, then I'll be creating a list of checkboxes, so that the user can decide exactly which changes he/she wants kept. Wish me luck!Comment
Comment