Last post May 31, 2011 05:53 AM by uttam24
May 27, 2011 08:33 AM|uttam24|LINK
I have a more than 60 field to insert into database. So I break up the pages in three parts. After complete the first part the Second page will open and then the 3rd one. Now my problem is that i want to store all the after the completion of the 3rd page.
So i store the values in temp value and pass in session. But i think it will be overloaded for the server it lots of user use at the same time. Is there any other option apart from the session and i also donot want to create a temporary table in the database.
May 27, 2011 08:52 AM|Steelymar|LINK
I will propose to insert into original table first page and store in session the returned ID from DB. On second and third page update this record.
In your case if the server is overloaded store the session in DB.
May 27, 2011 08:55 AM|atulthummar|LINK
Another option is to use SortedList object contains items in key/value pairs. A SortedList object automatically sort the items in alphabetic or numeric order.
And Finally Stored SortedList into Session Object.
May 27, 2011 04:13 PM|budugu|LINK
Is there any other option apart from the session and i also donot want to create a temporary table in the database. Pls advice
ASP.NET State Management Recommendations
May 30, 2011 02:35 AM|uttam24|LINK
I did the same thing. Store the first page data in original table and update the second and 3rd page according to the ID (unique). Most of the time it works well, but some time i got the incomplete information in DB.
May 30, 2011 04:58 AM|Steelymar|LINK
You should have a flag “Completed” for example… and when update data from last page set the flag to true.
Now you can rewrite all your SQL to get only Completed=true or create a View containing this filter.
Next step is to delete all old record that isn’t completed.
May 31, 2011 05:53 AM|uttam24|LINK
Thanks for the nice idea. I'll definately do that.