Access里插入时间字段的SQL怎么写? Insert into mytable (TimeField) Values (#2004-3-17 9:00:00#); 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 转化成data类型试试如果试现在的时间可以用Now Dim postZT As String = txtZT.Text Dim postLR As String = parset(TxtLR.Value) Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=" & Server.MapPath("data\Plane_club.mdb") Dim strCommand As String ConnClub = New OleDbConnection(strConn) 'Dim AdapterClub As OleDbDataAdapter 'Dim dsClub As DataSet = New DataSet strCommand = "insert into newpost(FTR,ZT,LR,FTSJ,ZHGXSJ) values ('" strCommand += logUser.YHM & "'" strCommand += ",'" & postZT & "'" strCommand += ",'" & postLR & "'" strCommand += ",'" & Now() & "'" strCommand += ",'" & Now() & "')" 'AdapterClub.= strCommand Dim cmdClub As OleDbCommand = New OleDbCommand(strCommand, ConnClub) ConnClub.Open() cmdClub.ExecuteNonQuery() '关闭连接 ConnClub.Close() ljmay168(軍) 兄还是insert语法错误啊 試試這個Insert into mytable (TimeField) Values (cdate('2004-3-17 9:00:00')); Repeater的分页,各位大哥求教啊!急急急!!! SQL缓存依赖出现了问题,请教各位。 .NET高手死光了? 这种情况下如何让div显示滚动条?? 在一个textbox里输入5个字符窜的内容后,自动转到第二个textbox {MDaemon6}如何用发邮件方式修改密码 在使用odp.net连接数据库,获取日期型的数据时老是不能正确获取,怎么办? 复合自定义控件的子控件宽度自动匹配控件的宽度? 数据库操作错误~ 大家帮我看看! 关于Visio2002版的安装问题 求一个例子(选地区的下拉列表)! 那里可以找到留言板的源代码
如果试现在的时间可以用Now
Dim postLR As String = parset(TxtLR.Value)
Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=" & Server.MapPath("data\Plane_club.mdb")
Dim strCommand As String
ConnClub = New OleDbConnection(strConn)
'Dim AdapterClub As OleDbDataAdapter
'Dim dsClub As DataSet = New DataSet
strCommand = "insert into newpost(FTR,ZT,LR,FTSJ,ZHGXSJ) values ('"
strCommand += logUser.YHM & "'"
strCommand += ",'" & postZT & "'"
strCommand += ",'" & postLR & "'"
strCommand += ",'" & Now() & "'"
strCommand += ",'" & Now() & "')"
'AdapterClub.= strCommand
Dim cmdClub As OleDbCommand = New OleDbCommand(strCommand, ConnClub) ConnClub.Open() cmdClub.ExecuteNonQuery()
'关闭连接
ConnClub.Close()
还是insert语法错误啊
Insert into mytable (TimeField) Values (cdate('2004-3-17 9:00:00'));