GridView transferring changes at end-of-edit

  • Thread starter Thread starter R.A.M.
  • Start date Start date
R

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/
 
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.
 
Back
Top