Best way to save Gridview for later use

Question

We have a dynamically built Gridview. I would like to save this Gridview as history somewhere. It could be saved to database. Not exactly sure what is the best way to save the gridview history. User should be able to revisit this history to finalize the selection at later time or edit this gridview.

Vincent Maverick Durano · Answer

Two approaches: 1. Using sessions to store the data so that in the next page you can easily reference the value from Session. You can use DataTable/Collections/Custom objects or any forms of temporary data holder and then store the value in Session. Check this example: http://mikesdotnetting.com/Article/136/Sessions-and-Shopping-Carts 2. Second is using a Temporary Table in the database. This means that in the first page where you collect the data you can save them in a temporary table passing along the userid of the user. In the next page where you want to verify the data you can just query your temporary table based on the user ID and display them on the gridview . Once the order is finalize and confirmed you can now insert the data to your final table and clean up the data stored from your temporarily table. If you were to ask me I'd prefer option 2 because we can't really rely on Sessions for storing the data. Why is it? In ASP.NET the application pool frequently recycles and this is typically out of our control. When that happened all that in-memory state is lost.

Vincent Maverick Durano · Answer

Good to hear that. I'm glad to be of help.

Snehal Rana · Answer

Vincent the second option worked for me.

Chandu Kumawat · Answer

hi snehal .......... see about sql trigger atach trigger to gridview so u can check later

Vincent Maverick Durano · Answer

Awesome! Just one favor please don't forget to close this thread by marking helpful post as answer for the sake of the future readers. Good luck on your development. :)

Snehal Rana · Answer

Thanks Vincent I will tryout the second approach as I am not a big fan of storing data in Session. Will post the update here