Adding Items in a datagrid

[Guest]

I have binded the two datagrids from database from two different tables. In
both datagrids, the first column contains checkbox. In between the datagrid,
i have "Add -->" and "Remove -->" buttons in between the datagrids. When i
select some items in the first datagrdi and click on "Add -->" button, the
selected items from the first datagrid should added to the second datagrid.
Similarly for the "Remove -->" button also. I should not connect to database
until i click on "Save" button. All the items that are added should be
inserted into the database when i click on "Save" button. Both datagrids are
Custom controls. How can we achieve this functionality.

Any help most welcome.

Regards
G.V.Srinivasa Rao.

 

[Scott Allen]

Hi Srinivasa:

Not being able to insert the data until clicking the save button is
always a little tricky. You'll have to carry the state of the data
around between user postbacks. One solution would be to keep both
tables of data in a DataSet and keep the DataSet in the Session - if
Session is available in your architecture.

Once the Save button event fires you can use DataAdapter.Update to
move new records into the database.

Making any sense?