Carl,
This should work. DataSets *are* serializable. It's been awhile since I've played around with this (more than a year ago), but I'm certain I had it working ... I wanted to be sure that we could have a scalable application, so I was looking into managing the session state on SQL Server as you've mentioned (but since then, we haven't done much with the WebForm part of our app because we've been focusing on WinForms).
Have you read this article? Visual Studio Magazine, "Manage Session State on the Server":
http://www.fawcette.com/vsm/2003_10/magazine/columns/aspnet/I'm certain that there must be something you're missing, but I'm not sure what it could be. Perhaps the above article might give you a clue.
~~Bonnie
>To scale a web application to run in a web farm environment, one option to managing sessions is through SQLServer. However, if a you try to store a dataset to a session, an error results "Object must be serializable..." Ironically, the MS docs indicate that the dataset is serializable. Yet ASP.NET thinks otherwise.
>
>Has anyone figured out how to store a dataset in an out-of-proc session using SQLServer.
>
>This should work but does not:
>
>
>Dim ds As DataSet = MyBizObject.GetByID(myID)
>Session("myDataSet") = ds
>
>
>Thanks!
>
>Regards,
>Carl.