using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;public partial class Interaction_chat : System.Web.UI.Page
{
private readonly string SQLCONNECTIONSTRING = ConfigurationSettings.AppSettings["SQLCONNECTIONSTRING"].ToString();
protected void Page_Load(object sender, EventArgs e)
{
if (Session["user"] != null && Session["user"] != "")
{
setOnline();
Response.Redirect("chat_frame.aspx");
}
}
private void setOnline()
{
string cmdText = "UPDATE Users SET isonline= 1 WHERE user_id = '" + Session["id"].ToString().Trim() + "'";
SqlConnection myConnection = new SqlConnection();
myConnection.ConnectionString = SQLCONNECTIONSTRING;
SqlCommand myCommand = new SqlCommand(cmdText, myConnection);
myConnection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close();
}
}请问为什么我的setOnline()方法只在编译后第一次运行时被调用!
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;public partial class Interaction_chat : System.Web.UI.Page
{
private readonly string SQLCONNECTIONSTRING = ConfigurationSettings.AppSettings["SQLCONNECTIONSTRING"].ToString();
protected void Page_Load(object sender, EventArgs e)
{
if (Session["user"] != null && Session["user"] != "")
{
setOnline();
Response.Redirect("chat_frame.aspx");
}
}
private void setOnline()
{
string cmdText = "UPDATE Users SET isonline= 1 WHERE user_id = '" + Session["id"].ToString().Trim() + "'";
SqlConnection myConnection = new SqlConnection();
myConnection.ConnectionString = SQLCONNECTIONSTRING;
SqlCommand myCommand = new SqlCommand(cmdText, myConnection);
myConnection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close();
}
}请问为什么我的setOnline()方法只在编译后第一次运行时被调用!
语句Response.Redirect("chat_frame.aspx");得到执行!
换为
Response.Write("<script language='javascript'>window.location.href='chat_frame.aspx'</script>");
试下