62,025
社区成员
发帖
与我相关
我的任务
分享
<%@ Application Language="C#" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Data" %>
<script runat="server">
void Application_Start(object sender, EventArgs e)
{
//在应用程序启动时运行的代码
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["TongJiConnectionString"].ConnectionString;
con.Open();
SqlCommand cmd = new SqlCommand("select * from tongji", con);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataTable dt = new DataTable();
da.Fill(dt);
//int count = Convert.ToInt32(cmd.ExecuteScalar());
con.Close();
Application["total"] = Convert.ToInt32(dt.Rows[0]["Number"].ToString());
Application["online"] = 0;
}
void Application_End(object sender, EventArgs e)
{
//在应用程序关闭时运行的代码
// 在应用程序关闭时运行的代码
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["TongJiConnectionString"].ConnectionString;
con.Open();
SqlCommand cmd = new SqlCommand("update tongji set Number=" + Application["total"].ToString(), con);
cmd.ExecuteNonQuery();
con.Close();
}
void Application_Error(object sender, EventArgs e)
{
//在出现未处理的错误时运行的代码
}
void Session_Start(object sender, EventArgs e)
{
//在新会话启动时运行的代
Application.Lock();
Application["total"] = (int)Application["total"] + 1;
Application["online"] = (int)Application["online"] + 1;
Application.UnLock();
}
void Session_End(object sender, EventArgs e)
{
//在会话结束时运行的代码。
// 注意: 只有在 Web.config 文件中的 sessionstate 模式设置为
// InProc 时,才会引发 Session_End 事件。如果会话模式
//设置为 StateServer 或 SQLServer,则不会引发该事件。
Application.Lock();
Application["online"] = (int)Application["online"] - 1;
Application.UnLock();
}
</script>
//string strIP = Page.Request.UserHostAddress;
//System.Net.IPAddress ip = System.Net.IPAddress.Parse(Request.UserHostAddress); //根据目标ip地址的获取ip对象
//System.Net.IPHostEntry ihe = System.Net.Dns.GetHostEntry(ip); //根据ip对象创建主机对象
//string UserHostName = ihe.HostName;
void Session_Start(object sender, EventArgs e)
{
//在新会话启动时运行的代
Application.Lock();
Application["total"] = (int)Application["total"] + 1;
Application["online"] = (int)Application["online"] + 1;
Application.UnLock();
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["TongJiConnectionString"].ConnectionString;
con.Open();
SqlCommand cmd = new SqlCommand("update tongji set Number=" + Application["total"].ToString(), con);
cmd.ExecuteNonQuery();
con.Close();
}