请问如何将Session存储在SqlServer中？
如题 问题点数：50、回复次数：5Top
1 楼saucer（思归）回复于 2004-12-01 11:59:42 得分 50
HOW TO: Configure ASP.NET for Persistent SQL Server Session State Management
http://support.microsoft.com/default.aspx?kbid=311209Top
2 楼zlc810821（卷心菜）回复于 2004-12-01 12:38:32 得分 0
Thank you for the help from saucer.
I have downloaded it from that URL. But I don't know how to use it in asp.net.
Could you help me to use it? Or give some samples to me . Thanks.Top
3 楼zlc810821（卷心菜）回复于 2004-12-01 12:46:04 得分 0
I have got some information of using aspSessionState from Microsoft.
////////////////////
Configuring Session State
You can configure session state in the <sessionState> configuration section of the Web.config file. The <sessionState> configuration section appears similar to the following: <sessionState mode="SQLServer"
stateConnectionString="tcpip=127.0.0.1:42424"
sqlConnectionString="data source=127.0.0.1;user id=<username>;password=<strong password>"
cookieless="false"
timeout="20" />
/////////////////////
Top
4 楼zlc810821（卷心菜）回复于 2004-12-01 12:48:34 得分 0
I have successed .
Thank you saucer.Top
5 楼muse2008（沉思）回复于 2004-12-01 12:55:22 得分 0
在Winnt\Microsoft.Net中找到InstallSqlState.sql文件，然后在SQL Server 中执行它。在于C:\WINNT\Microsoft.NET\Framework\v1.0.2914\下。
修改Web.config文件:
<sessionState
mode="SQLServer"
sqlConnectionString="data source=127.0.0.1;userid= sa;password="
cookieless="false"
timeout="20"
/>Top
