Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 1.0 and 1.1 > ASP.NET 1.1
|
ASP.NET 1.1 As of 10/6/2005, this forum is locked as part of the reorganization described here: http://p2p.wrox.com/topic.asp?TOPIC_ID=35394. No posts have been deleted. Open ongoing discussions from the last week have been moved to either ASP.NET 1.0 and 1.1 Beginners http://p2p.wrox.com/asp-net-1-0-1-1-basics-60/ or ASP.NET 1.0 and 1.1 Professional. http://p2p.wrox.com/forum.asp?FORUM_ID=50. See my sticky post inside for more.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.1 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 1st, 2004, 06:26 AM
Registered User
 
Join Date: Oct 2003
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default How to store Session data in SQL Server

Because of losing Session data when the worker process is recycled it is recommended to store Session Data in SQL Server. I need any example how to store and restore Session data in SQL Server

Michael
 
Old March 1st, 2004, 12:12 PM
planoie's Avatar
Friend of Wrox
 
Join Date: Aug 2003
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

Building your own session management is no trivial task. First, you'll need to consider what kind of table structure you'll need to use. Then you'll need to construct a .NET class that has some kind of collection in it so the pages can interface to the data. A major factor on much of this is that you will have to determine whether or not you want to suppose objects in your custom session management. The built in session management system supports saving objects (this topic in itself can spark religious debates). If you are willing to make the sacrifice to only store simple types in your session data than it's really not that hard. You could extend one of the existing collection classes for use as your session value collection. Then you just need to plug in the storage and retrieval of the data within the page. There are some simple techniques that you can use that I can explain later once you get to that point.

Peter
------------------------------------------------------
Work smarter, not harder.





Similar Threads
Thread Thread Starter Forum Replies Last Post
How to store image in sql server database Debmit_das ASP.NET 2.0 Basics 5 March 21st, 2008 05:31 AM
MS SQL SERVER STORE PROCEDURE and schedulling kumiko Classic ASP Basics 2 June 8th, 2007 01:03 AM
How to store data in a session using javascript? chayan Classic ASP Professional 0 March 10th, 2007 10:14 AM
Store an picture in SQL Server ashoka_klt SQL Server 2000 1 October 29th, 2006 11:27 PM
can we store audio files in SQL Server bugsfree Pro JSP 0 August 27th, 2006 02:28 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.