繁體中文当前位置: 首页 > 图文教程 > 网络编程 > ASP > ASP.NET:处理session
- ASP
- ADO如何提供异动功能？（BIG5）
- 从数据库中动态选取下拉列表的方法
- 数 据 库 设 计 经 验 谈
- 用SQL实现分布式数据复制
- NT4的ODBC与SQL7相连，不支持中文？
- 大部分ADO的错误码对应的含义
- ASP+中取代ASP的RS(Remote Scripting)技术的Framework
- 利用Page.IsPostBack属性保持用户输入的Framework
- 用VB6读写数据库中的图片
- VisualInterDev6.0七种实现分页显示的方法
- 利用ASP获得图象的实际尺寸的示例
- 5个实用的ASP网站功能（GIB5）
- 在ＡＳＰ中用集合成批操作数据库
- 用asp管理sql server数据库
- 用asp处理access数据库
- 使用速度更快的OLEDB取代ODBC连结
- 对Query字段进行Encode操作的一点看法
- 用ASP语言实现对SQL SERVER 数据库的操作
- Microsoft SQL Server 7.0 备份及恢复相关问题
- Microsoft SQL Server 7.0数据库升级转换问题
ASP.NET:处理session
出处:互联网 整理: 软晨网（RuanChen.com） 发布: 2009-11-03 浏览: 84 ::
收藏到网摘: n/a
Introduction
Hi When I started working with this technology I faced a problem dealing with session as in any transaction or Database oriented portal this is a must requirement to deal with.
Here is a simple example showing the way to maintain session as in the first piece of code it is taking the Author first name then opening the database i am taking authors LastName and AuthorID which is there to put in session which i can access in the next Page. It will be redirected to the next Page and in the Page_Load function only i am printing the Author full name (First and Last name) and Author ID.The only thing to be taken care is give the name which are already there in the DataBase as author first name (Example Jhonson)
Source Code PutSession.aspx, GetSession.aspx
PutSession.aspx
<%@ Page language="C#" enablesessionstate=true%>
<%@ Import Namespace="System.IO" %>
<%@ Import Namespace="System.Text" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SQL" %>
<script language="javascript"
src="/_aspx/1.0.2204/script/WebUIValidation.js">
</script>
<script language = "C#" runat ="server">
public String Mystr;
public String adminTypeID;
public String associationID;
public SQLDataReader myReader;
public void SubmitBtn_Click(Object sender, EventArgs e) {
if (Page.IsValid) {
SQLConnection myConnection = new SQLConnection("server=localhost;uid=sa;pwd=;database=pubs");
SQLCommand myCommand = new SQLCommand("Select au_lname,au_id from Authors where au_fname ='"+firstname.Text+"'", myConnection);
try
{
myConnection.Open();
myCommand.Execute(out myReader);
Session["aufname"] = firstname.Text;
while (myReader.Read())
{
Session["aulname"] = myReader["au_lname"];
Session["auid"] = myReader["au_id"];
Response.Redirect("GetSession.aspx");
}
}
catch(InvalidCastException exp)
{
Response.Write(exp.ToString());
}
}
}
String GetSession(String key) {
return Session[key].ToString();
}
</script>
<html>
<title>
Maintaining Session
</title>
<body bgcolor=#CCFFFF>
<form action="PutSession.aspx" method="post" runat="server">
<center>
<table width="360" border="1" cellspacing="0" cellpadding="2">
<tr bgcolor="#eeeeee">
<td>Hi U R First Name as Registered is(Only for those who r already there)</td>
<td><asp:TextBox size="25" id="firstname" value ="" runat="server"/></td>
<td> <asp:RequiredFieldValidator ControlToValidate="firstname" Display="Dynamic" errormessage="You must enter your name!" runat=server/> </td>
</tr>
<td align="right">
<asp:button type=submit text="GoGetIt" OnClick="SubmitBtn_Click" runat="server"/>
</center>
</form>
</body>
</html>
// GetSession.aspx
<%@ Page language="C#" enablesessionstate=true%>
<%@ Import Namespace="System.IO" %>
<%@ Import Namespace="System.Text" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SQL" %>
<script language="javascript"
src="/_aspx/1.0.2204/script/WebUIValidation.js">
</script>
<script language = "C#" runat ="server">
public string Aut
评论 (0) All
