GridView transferring changes at end-of-edit

[R.A.M.]

Hi,
I am learning ASP.NET and I need to have an Excel-like sheet of records from
database. Users may modify data in the sheet. I thought about using GridView
with DataSource but the problem is that the changes should be transferred to
database not when record is modified but when separate button is clicked
(then a transaction with inserts/updates/deletes should be performed). As I
understand database commands of DataSource are executed when records are
modified.
Do you know any good ideas? I think about storing (using DataSource
commands) changes in temporal table and then transferring changes to main
database table when button is pressed, but I don't know if it's a good
solution because implementation will be rather complicated as I guess.
/RAM/

[R.A.M.]

What do you think about this:

In InsertCommand I insert into temporal table #i
in UpdateCommand I insert into temporal table #u
in DeleteCommand I insert into temportal table #d
in SelectCommand I select from main table t and temporal tables:
( select * from t
union
select * from #i
except
select * from #d
union
select * from #u )
except
( select key from t
intersect
select key from #u ) .
On button click I transfer from temporal tables to main table t.

U¿ytkownik "R.A.M." <r_********@poczta.onet.plnapisa³ w wiadomo¶ci
news:em**********@news.onet.pl...

I think about storing (using DataSource commands) changes in temporal
table and then transferring changes to main database table when button is
pressed, but I don't know if it's a good solution because implementation
will be rather complicated as I guess.