session_end

显示全部楼层 · 2010-9-15 19:05:00

void Session_End(object sender, EventArgs e)
{

SqlCon con = new SqlCon();

SqlDo sqldo = new SqlDo();

if (Request.Cookies["Usersdd"] != null)//记录用户名显示

{

HttpCookie cool = Request.Cookies["Usersdd"];

SqlDataReaderre;

string path;

path = "select LastTime from all_Users where uId=" + Convert.ToInt16(cool.Values["uId"].ToString()) + "";

using (re = sqldo.GetRow(path))

{

if (re.Read())

{

DateTime fortime = re.GetDateTime(0);//获取登录时间

re.Close();

DateTime loginouttime = DateTime.Now;

TimeSpan ontime = loginouttime.Subtract(fortime);//获得时间差就是登录时间

int longtime = Convert.ToInt32(ontime.Seconds.ToString()) + Convert.ToInt32(ontime.Minutes.ToString()) * 60 + Convert.ToInt32(ontime.Hours.ToString()) * 3600

string updated = "Update all_Users set OnlineTime=OnlineTime+" + longtime + " where uId=" + Convert.ToInt16(cool.Values["uId"].ToString()) + "";

sqldo.doSql(updated);

}

con.SqlClose();

}

Session.Clear();

Session.RemoveAll();

Session.Abandon();

}
这里用的cookie来操作数据库没有反映，但是换成session["uId"]就有反映，我想问，在session_end中不能用cookie吗？

千问 · 2010-9-15 19:05:00

Cookie是保存在客户端的；session是保存在服务器端