Last post Oct 30, 2013 08:34 AM by Illeris
Oct 24, 2013 07:33 AM|p.bhattacharyya|LINK
Thanks in advance....
I wanna create application for User Registration for website. The registration process will be completed in 4 steps. On each step user will input some data. I wanted to save the information into database.
I am bit confused which approach to be used from below list.
Shall I insert all data in a single transaction when the registration is completed?
Shall I insert data by using a single transaction after each page?
Few things that needs to be considered
Registered User info should be available only after registeration is completed.
Please suggest if there is other way possible.
Oct 24, 2013 08:03 AM|ramana123|LINK
I would say have a pre-registration tablr where save all the data uintil final submit; when final submit done delte from pre-registration and add into registration table.
Note: need to find a way to make it pre-registration table valid like some users may perform until step:2 and leave then need to ensure they are cleared from pre-registration table.
Dont know if keeping all the values into sessiosn until final step is a good option but I would say it wil lbe heavy performance hit may b there. just a thougt
Oct 30, 2013 08:34 AM|Illeris|LINK
Use this for the wizard : http://msdn.microsoft.com/en-us/library/w7dyf6b5(v=vs.90).aspx
Furthermore : collect data in memory (session) until the end, then submit the entire structure at once to your dbase