ASP.NET:处理session
日期：2011-03-26 浏览次数：20462 次
Shivani
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" 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 AuthorFirstName;
public string AuthorLastName;
public string AuthorID;
public void Page_Load(Object sender, EventArgs e) {
if (Page.IsValid)
{
AuthorFirstName = GetSession("aufname");
AuthorLastName = GetSe
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" 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 AuthorFirstName;
public string AuthorLastName;
public string AuthorID;
public void Page_Load(Object sender, EventArgs e) {
if (Page.IsValid)
{
AuthorFirstName = GetSession("aufname");
AuthorLastName = GetSe
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
