How to make bulk update using TableAdapter

[andhrawala1983]

Hi ,

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

http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/cac3ab15-9236-4e6a-9ec1-f3cd73c91641

The explanation is very clear but I need it with an example.

Thanks in advance.

[vuyiswam]

Didn't i give you a Solution to this problem in codeProject ?