如何在Sql Server数据库中存储会话使用Asp.Net4.0 [英] How to store session in Sql Server data base Using Asp.Net4.0

问题描述

亲爱的所有人，

我迫切需要在sql数据库中存储会话变量。

请有人帮助我。我不知道这个概念。

谢谢和问候，

Atul Sharma

Dear All,
I have urgent requirement to store session variable in sql database.
Please someone help me. I am unknown about this concept.
Thanks & Regards,
Atul Sharma

推荐答案

首先要了解什么是会议状态并继续你的要求...



在ASP.NET中探索会话 [ ^ ]





了解ASP.NET中的会话管理技术 [ ^ ]



http://asp.net-tutorials.com/state/sessions/ [ ^ ]

First understand the what is session state and go ahead with your requirements...

Exploring Session in ASP.NET[^]


Understanding Session Management Techniques in ASP.NET[^]

http://asp.net-tutorials.com/state/sessions/[^]

参考这些链接



如何：配置SQL Server以存储ASP.NET会话状态 [ ^ ]



在SQL Server数据库中监视会话状态 [< a href =http://www.developer.com/net/asp/article.php/3595766/Storing-Session-State-in-a-SQL-Server-Database.htmtarget =_ blanktitle =新窗口> ^ ]



问候：笑：

Refer these links

HOW TO: Configure SQL Server to Store ASP.NET Session State[^]

Storing Session State in a SQL Server Database[^]

Regards :laugh:

string admin="admin";
session["data"]=admin;

if(session["data"]!=null)
{

string  sql="insert into table values('"+session["data"].tostring().trim()+"')";

sqlconnection con=new sqlconnection(connectionstring);

con.open();

sqlcommand com=new sqlcommand(sql,con);

com.ExecuteNonQuery();

con.close();
}

这篇关于如何在Sql Server数据库中存储会话使用Asp.Net4.0的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！