ASP.NET, closing browser window

Question

Suppose I have an ASP.NET registration wizard. The collected information for each step is temporary stored in a database table, when clicking “Next”. Now suppose the user closed the browser window, or computer was unexpectedly shut down. So in that the application should delete all the temporary registration information. How could it be done?

Additional information: I cannot use cannot use a Session object because the application is served from a webfarm.

I thought already about using a stored procedure for clean up the table. But want to find out other possibilities.

walther · Accepted Answer · 2012-08-19 14:17:56Z

2

Simply do not store into db data that is incomplete. Use a session as a temporary storage instead. It gives you not only a better performance (you avoid db hits), but it avoids problems like yours altogether. Store to database only after all necessary info has been inputted.

answered Aug 19, 2012 at 14:17

walther

13.6k5 gold badges44 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

AD.Net · Accepted Answer · 2012-08-19 14:18:09Z

0

In such scenario, you can assign a temporary registration id for each session/attempt. If the window is closed, next attempt will be a new one and the application should run a clean up job every night or so to delete incomplete attempts.

answered Aug 19, 2012 at 14:18

AD.Net

13.4k2 gold badges30 silver badges47 bronze badges

Collectives™ on Stack Overflow

ASP.NET, closing browser window

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related