注册 登录
编程论坛 ASP.NET技术论坛

如何实现写入登录后的时间IP和次数?

swalia 发布于 2008-01-10 12:20, 894 次点击
string Userid = this.Userid.Value.ToString();
        string PassWD = this.Userpwd.Value.ToString();
        SqlConnection strcon = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["strcon"]);
        strcon.Open();
        SqlCommand scd = new SqlCommand("select count(*) from Users where Userid='" + Userid + "' and PassWD='" + PassWD + "' and IsGood=0 ", strcon);
        int count = Convert.ToInt32(scd.ExecuteScalar());
        // SqlDataReader dr = scd.ExecuteReader();
        if (count > 0)
        // int times = 0;
        // try
        {
            // if (!dr.Read())

            count = 1;
            string LoginDate = DateTime.Now;
            Session.Timeout = 30;
            Session["Userid"] = this.Userid.Value.ToString();
            Session["VNum"] = null;
            Response.Redirect("~/index.aspx");
        }
下面应该怎么样能写入登录的时间.IP和次数
2 回复
#2
guming2008-01-10 13:37
写入到数据库吗?或者说还是看得不是很明白
#3
swalia2008-01-10 16:40
是的,写入到该会员的数据中修改掉原先他登录的时间和IP及次数
1