Asp.net UpdateLog

public void UpdateLog(string loginName)

{

OleDbConnection myConn = GetConnection();

String sql = "update NwebCn_Admin set LastLoginTime=@LastLoginTime,LastLoginIP=@LastLoginIP where AdminName= @AdminName";

OleDbCommand myCmd=new OleDbCommand(sql,myConn);

myCmd.Parameters.Add(new OleDbParameter("@LastLoginTime"), OleDbType.Date, 8);

myCmd.Parameters["@LastLoginTime"].Value=System.DateTime.Now();

myCmd.Parameters.Add(new OleDbParameter("@AdminName"),OleDbType.VarChar,50);

myCmd.Parameters["@AdminName"].Value=loginName;

myCmd.ExecuteScalar();

myCmd.Dispose();

myConn.Close();

}

原文地址:https://www.cnblogs.com/lv_yantao/p/1413337.html