Store Database / Gridview changes until Saved
Posted on 2010-11-16
At this point I'm looking for a nudge in the right direction or a statement telling me this isn't possible...
Let's say I have a GridView that is linked to tblContacts. As it stands, the user can modify any of the displayed records within this GridView by choosing Edit, making the changes, and clicking Update which in turn updates the database in real-time which is okay; however, I would like to be informed of the changes that have taken place - I suppose via email. Ideally, the user would make all of the changes they desire within the GridView and then click Save Changes or the likes and the appropriate statements would be passed to the database along with an email fired off with a list of the changes made. Sorry for the rather broad topic. I'm unsure as to where I should start. Would I put all of the update/insert commands from the GridView into Storedprocedures which don't fire until Save Changes is clicked? :S TIA