读书人

为何提示 SQL 命令未正确结束

发布时间: 2013-06-26 14:29:32 作者: rapoo

为啥提示 SQL 命令未正确结束?

        Dim cmd As New OracleCommand
cmd.CommandText = "select * from Biao1 where JBSJ=2013/6/21 21:39:13
cmd.Connection = OrclConn
cmd.CommandType = CommandType.Text
Dim OrclAdp As New OracleDataAdapter
OrclAdp.SelectCommand = cmd
Dim ds As New DataSet
Try
OrclAdp.Fill(ds, TableName)
Catch ex As Exception
MsgBox(ex.Message)
Return Nothing
End Try

其中JBSJ是Biao1中date类型的字段,执行时提示: SQL 命令未正确结束?
是怎么回事,如何解决? 连接的是oracle数据库
[解决办法]
是不是少引号?另外JBSJ=2013/6/21 21:39:13这种写法可以吗?
[解决办法]
又错了,是

cmd.CommandText = "select * from Biao1 where JBSJ="'"&datetimepicker1.value&"'";

[解决办法]
cmd.CommandText = "select * from Biao1 where JBSJ=2013/6/21 21:39:13

这里错了
[解决办法]
cmd.CommandText = "select * from Biao1 where JBSJ='"&datetimepicker1.value&"'";

读书人网 >VB Dotnet

热点推荐