在SQL DB中我定义了一个表字段为DataTime,在ASP.NET中怎么写SQL语句插入当前时间insert into PersonInfo values ('1','a','a','a','男','11111111','[email protected]',GetDate())
在SQL中这样写可以加入当前系统时间,但在ASP.NET中应该怎么写此语句呢?cmd=new SqlCommand ("insert into PersonInfo(psUserName,psUserPwd,psRealName,psSex,psPhoneNum,psEmail,psRegDate) values ('"+pi.m_strUserName+"','"+pi.m_strUserPwd+"','"+pi.m_strRealName+"','"+pi.m_strSex+"','"+pi.m_strPhoneNum +"','"+pi.m_strEmail +"','"+GetDate() +"')",con);显示此错误
E:\ASP\JCCC2\PersonOperate.cs(42): 名称“GetDate”在类或命名空间“JCCC2.PersonOperate”中不存在
在SQL中这样写可以加入当前系统时间,但在ASP.NET中应该怎么写此语句呢?cmd=new SqlCommand ("insert into PersonInfo(psUserName,psUserPwd,psRealName,psSex,psPhoneNum,psEmail,psRegDate) values ('"+pi.m_strUserName+"','"+pi.m_strUserPwd+"','"+pi.m_strRealName+"','"+pi.m_strSex+"','"+pi.m_strPhoneNum +"','"+pi.m_strEmail +"','"+GetDate() +"')",con);显示此错误
E:\ASP\JCCC2\PersonOperate.cs(42): 名称“GetDate”在类或命名空间“JCCC2.PersonOperate”中不存在
cmd=new SqlCommand ("insert into PersonInfo(psUserName,psUserPwd,psRealName,psSex,psPhoneNum,psEmail,psRegDate) values ('"+pi.m_strUserName+"','"+pi.m_strUserPwd+"','"+pi.m_strRealName+"','"+pi.m_strSex+"','"+pi.m_strPhoneNum +"','"+pi.m_strEmail +"',getdate())",con);
1、把设置该列的默认值为:(getdate())
2、cmd=new SqlCommand ("insert into PersonInfo(psUserName,psUserPwd,psRealName,psSex,psPhoneNum,psEmail,psRegDate) values ('"+pi.m_strUserName+"','"+pi.m_strUserPwd+"','"+pi.m_strRealName+"','"+pi.m_strSex+"','"+pi.m_strPhoneNum +"','"+pi.m_strEmail +"',GetDate())",con);
3、cmd=new SqlCommand ("insert into PersonInfo(psUserName,psUserPwd,psRealName,psSex,psPhoneNum,psEmail,psRegDate) values ('"+pi.m_strUserName+"','"+pi.m_strUserPwd+"','"+pi.m_strRealName+"','"+pi.m_strSex+"','"+pi.m_strPhoneNum +"','"+pi.m_strEmail +"','"+System.DateTime.Now() +"')",con);
================================
孤心夜雪信息亭:
www.aiwo1314.com