Partly Save the data on button submit click

Question

User-1662538993 posted

I have one webform which i have used jquery ui tab control and made four tabs.

On my every tab I have button that take user to next page.

At the last stage when user click submit button it saves all the data to database.

I would like to save the data that is on the first tab to some kind of temp database or internally so if user have some problem in the data to database at last stage then either it will be saved to that temp table or it will be saved to internal datatable so i can use to fill that textbox back with the value or they can be saved it to database so i can show it back to them.

Thanks

Answer 1

User2009967717 posted

Use a temporary table identical to the other table in the database or have a bit indicator in your row that says it is a temporary row.

Answer 2

User533502567 posted

On my every tab I have button that take user to next page.

 

On button click event, you can store those values in cookies, session, cache..etc

Read this.. ASP.NET State Management Recommendations<!---->

Answer 3

User154448021 posted

you could also make all the fields allow null in the database and save partial data to the table in each step.  This way, all you need to retrieve from step to step is the primary key for that row in the table.  

Answer 4

User604186779 posted

I would like to save the data that is on the first tab to some kind of temp database or internally so if user have some problem in the data to database at last stage then either it will be saved to that temp table or it will be saved to internal datatable so i can use to fill that textbox back with the value or they can be saved it to database so i can show it back to them.

you can store the data in the DataTable - Creating through code and pass it to the session - finally - you get the data from the Datatable and store it on Database.

http://alperguc.blogspot.com/2008/11/c-and-aspnet-create-table-dynamically.html