I have a small requirement, which I am unable to complete.
I am having a gridview on the form, and the data is bined to the grid using ObjectDatasource that is inturn binding from a TableAdapter in the dataset.
I have all select,insert,update and delete commands specified.
When i click on update or insert or delete it is just working fine as it is intended to.
It is directly updating/inserting/deleting in the database.
My requirement now is it should not update directly in the database instead it should update the database on click of a "Save" button at the bottom of the page.
All the changes he had made till now in the grid should directly updated in the database at one shot.
I dont want to store in either in a variable or in a session. Because of the memory constraint.
Is there any efficient way. I have tried googling all around and one link I found which is similar is
The explanation is very clear but I need it with an example.
Thanks in advance.