62,046
社区成员
发帖
与我相关
我的任务
分享
<%@ Control Language="C#" AutoEventWireup="true" CodeFile="HeartBeat.ascx.cs" Inherits="HeartBeat" %>
using System;
using System.Configuration;
using System.Data.SqlClient;
public partial class HeartBeat : System.Web.UI.UserControl
{
protected void Page_Load(object sender, EventArgs e)
{
var sql = string.Format("if exists(select * from HeartBeat where SessionId='{0}') " +
"update HeartBeat set Time='{1}' where SessionId='{0}'; else " +
"insert HeartBeat(SessionId,Time) values ('{0}','{1}')", Session.SessionID, DateTime.Now.ToString("yyyy-M-d h:m:s"));
using (var sqlconn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString1"].ConnectionString))
{
var comm = new SqlCommand(sql, sqlconn);
sqlconn.Open();
comm.ExecuteNonQuery();
}
}
}
然后,把它拖入每一个aspx。[/quote]
大神的指导<%@ Control Language="C#" AutoEventWireup="true" CodeFile="HeartBeat.ascx.cs" Inherits="HeartBeat" %>
[code=csharp]using System;
using System.Configuration;
using System.Data.SqlClient;
然后,把它拖入每一个aspx。[/quote]
非常感谢,我来试试!<%@ Control Language="C#" AutoEventWireup="true" CodeFile="HeartBeat.ascx.cs" Inherits="HeartBeat" %>
using System;
using System.Configuration;
using System.Data.SqlClient;
public partial class HeartBeat : System.Web.UI.UserControl
{
protected void Page_Load(object sender, EventArgs e)
{
var sql = string.Format("if exists(select * from HeartBeat where SessionId='{0}') " +
"update HeartBeat set Time='{1}' where SessionId='{0}'; else " +
"insert HeartBeat(SessionId,Time) values ('{0}','{1}')", Session.SessionID, DateTime.Now.ToString("yyyy-M-d h:m:s"));
using (var sqlconn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString1"].ConnectionString))
{
var comm = new SqlCommand(sql, sqlconn);
sqlconn.Open();
comm.ExecuteNonQuery();
}
}
}
然后,把它拖入每一个aspx。[/quote]
高手,学习了<%@ Control Language="C#" AutoEventWireup="true" CodeFile="HeartBeat.ascx.cs" Inherits="HeartBeat" %>
using System;
using System.Configuration;
using System.Data.SqlClient;
public partial class HeartBeat : System.Web.UI.UserControl
{
protected void Page_Load(object sender, EventArgs e)
{
var sql = string.Format("if exists(select * from HeartBeat where SessionId='{0}') " +
"update HeartBeat set Time='{1}' where SessionId='{0}'; else " +
"insert HeartBeat(SessionId,Time) values ('{0}','{1}')", Session.SessionID, DateTime.Now.ToString("yyyy-M-d h:m:s"));
using (var sqlconn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString1"].ConnectionString))
{
var comm = new SqlCommand(sql, sqlconn);
sqlconn.Open();
comm.ExecuteNonQuery();
}
}
}
然后,把它拖入每一个aspx。