User Interface and Batch Inserts/Updates

[Dimitris Milonas]

Hello to all,

I have a DetailView on a page with Insert/Update enable and Paging enable. I
would like to have on the same page two buttons ("Submit" and "Cancel")
where with the first ("Submit") all the entries will be passed to the
database (Inserts - Updates - Deletes) while with the second ("Cancel") all
changes will be discarded.
Is it possible?
I' am using DataSet and DataAdapter and I have to execute
Adapter.Update(DataTable) every time that insert/update/delete records. It
seems that after inserting a record, the page is postback and rereads the
data from the databasewithout finding the newly inserted record unless I
execute Adapter.Update(DataTable)!
Is there a way to solve the problem?

Thanks in advance
Dimitris Milonas