1180
社区成员
- 主页
dtpicker进行筛选（between)问题
我用SQL数据库
srec.CommandType = adCmdText
srec.RecordSource = "select * from LINGRU where 日期 between '" & DTPicker1.Value & "' and '" & DTPicker2.Value & "'"
在datagrid中显示的是全部数据，根本没筛选？请问怎样解决!
srec.CommandType = adCmdText
srec.RecordSource = "select * from LINGRU where 日期 between '" & DTPicker1.Value & "' and '" & DTPicker2.Value & "'"
在datagrid中显示的是全部数据，根本没筛选？请问怎样解决!
...全文
请发表友善的回复…
发表回复
wwqna 2004-10-07
同意楼上
frankwong 2004-10-07
试一下:
srec.CommandType = adCmdText
srec.RecordSource = "select * from LINGRU where 日期 between '" & format( DTPicker1.Value ,"yyyy-mm-dd") & "' and '" & format( DTPicker2.Value,"yyyy-mm-dd") & "'"
srec.CommandType = adCmdText
srec.RecordSource = "select * from LINGRU where 日期 between '" & format( DTPicker1.Value ,"yyyy-mm-dd") & "' and '" & format( DTPicker2.Value,"yyyy-mm-dd") & "'"
kjset 2004-10-07
这样会出错
tztz520 2004-10-07
srec.RecordSource = "select * from LINGRU where 日期 between #" & DTPicker1.Value & "# and #" & DTPicker2.Value & "#"