如何保存登录放大器;注销时间在数据库使用ASP.NET

CREATE TABLE USERLOG(

   ID INT IDENTITY(1,1) PRIMARY KEY NOT NULL,

   USERID INT,

   LOGIN DATETIME,

   LOGOUT DATETIME

)

SqlConnection cs = new SqlConnection("YOUR CONNECTION STRING");

cs.Open();

SqlCommand cmd = new SqlCommand();

public void Login(int userID)

{            

   cmd.Connection = cs;

   cmd.CommandType = CommandType.StoredProcedure;

   cmd.CommandText = "SP_TRACK_USERLOG";

   cmd.Parameters.AddWithValue("@USERID", userID);

   cmd.Parameters.AddWithValue("@COMMAND", 0);

   cmd.ExecuteNonQuery();

}

public void LogOut(int userID)

{

   cmd.Connection = cs;

   cmd.CommandType = CommandType.StoredProcedure;

   cmd.CommandText = "SP_TRACK_USERLOG";

   cmd.Parameters.AddWithValue("@USERID", userID);

   cmd.Parameters.AddWithValue("@COMMAND", 1);

   cmd.ExecuteNonQuery();

}