I have a page that has a dataset is loaded on page load.
The user can add records to the dataset, and will not be updated
to the table the dataset was loaded from.

Right now I have it set up so that every time the page is loaded the dataset is loaded. And the add new record is performed with an insert into.

I want to change this so that I add to the dataset, and only update the table on submit. I can add a row to the dataset, but on the postback the row in the dataset is loss since the update to the table is not performed.

Should I be saving the dataset as a session variable and loading it on postback???

Thanks in advance.
Jimmer