我用datatable的方法,想在注册一个新的用户的同时,记录这一操作的当前系统时间,要怎么可以做到?public int AddLz(string sBPName, string sCname, string sDept, string smanageTime, string sMuser, string sRe)
{
//定义SQL语句
string cmdText = ADDLZ + "("
+ "'" + sBPName + "',"
+ "'" + sCname + "',"
+ "'" + sDept + "',"
+ "'" + smanageTime + "',"
+ "'" + sMuser + "',"
+ "'" + sRe + "'"
+ ")";
int nResult = SqlHelper.ExecuteNonQuery(ConfigurationManager.ConnectionStrings["SQLCONNECTIONSTRING"].ConnectionString,
CommandType.Text, cmdText);
return nResult;其中 smanageTime是存储系统时间的,类型是datetime
{
//定义SQL语句
string cmdText = ADDLZ + "("
+ "'" + sBPName + "',"
+ "'" + sCname + "',"
+ "'" + sDept + "',"
+ "'" + smanageTime + "',"
+ "'" + sMuser + "',"
+ "'" + sRe + "'"
+ ")";
int nResult = SqlHelper.ExecuteNonQuery(ConfigurationManager.ConnectionStrings["SQLCONNECTIONSTRING"].ConnectionString,
CommandType.Text, cmdText);
return nResult;其中 smanageTime是存储系统时间的,类型是datetime
程序 不用 操作 了
(
id int;
dt datetime default getdate()
)
DateTime.Now.ToString();//这个是客户端的时间
getdate();//这个是服务器的时间
程序 不用 操作 了操作的话,建议:DateTime.Now.ToString()获取,可以截取